Is there a way to check when a table or index needs an extent ?
How to check it ?
Printable View
Is there a way to check when a table or index needs an extent ?
How to check it ?
You'd have to run an analyze on it and check the number of empty blocks, and other stats ... or alternatively not worry about it and just let it extend as needed. I don't know of anyone who worries about this.