Extent sizing
Hi Everyone:
So I've read about as much as I can about how tablespace extent management has changed and become more efficient with each new Oracle release. I'm now working in 10G.
My question is: If you set your tablespace to locally managed and segment space management auto, is there any reason to set an initial and next extent irregardless of table size since Oracle is better at managing extents with these settings?
Can I assume that multiple sized tables in one tablespace does not matter as Oracle will figure it out and set the right next extent sizes so I don't have to worry about fragmentation?
So I've read about as much as I can about how tablespace extent management has changed and become more efficient with each new Oracle release. I'm now working in 10G.
My question is: If you set your tablespace to locally managed and segment space management auto, is there any reason to set an initial and next extent irregardless of table size since Oracle is better at managing extents with these settings?
Can I assume that multiple sized tables in one tablespace does not matter as Oracle will figure it out and set the right next extent sizes so I don't have to worry about fragmentation?
0