Re: Oracle 8.1.17 extent management
Date: Fri, 20 Jun 2008 23:50:20 +1000
Very much my choice as well for those earlier releases and even 10g. Fixed extents. Stay away from ASSM until at least 10.2.0.3: the number of nasty bugs with that allocation is astronomical until then. Particularly if you do anything out of the simple vanilla table/column design. Eg: LOBs, nested tables, indexing other than simple b-tree, MVs, log shipping, objects, etcetc.
-- Cheers Nuno Souto in overcast Sydney, Australia dbvision_at_iinet.net.au Andrew Kerber wrote,on my timestamp of 20/06/2008 10:51 PM:Received on Fri Jun 20 2008 - 08:50:20 CDT
> Locally managed fixed 1 meg extents (initial 1m, next 1m, pctincrease 0)
> works real well.