small table with more than 20 extents 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.