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.
"The Oracle Sponge"
Senior Manager, Business Intelligence Development
XM Satellite Radio