Re: Oracle 8.1.17 extent management

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:


> Locally managed fixed 1 meg extents (initial 1m, next 1m, pctincrease 0) 

> works real well.

> 

--
http://www.freelists.org/webpage/oracle-l