Database Administration (MOSC)

MOSC Banner

small table with more than 20 extents in 11g

edited Dec 12, 2011 5:55AM in Database Administration (MOSC) 7 comments
In the old days, oracle suggests to have small tables in one extents for better performance. Does this still hold true in 11g?

I have a relative small table right now have 913006 rows. It has about 26 extents now. The query from dba_segments showed initial_extent of 65536 and next extent of 1048576. My question is I am not sure in 11g, does the table storage get automatically managed? (Such as, will the next extent size automatically be bigger?) Should I reorg this table to have a bigger extent size at this point? I know I have this table store in an auto extent tablespace that is locally managed for the tablespace size. Please advise. Thank you very much.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center