Go to LMT asap. Whether you want to use uniform sized extents in LMTs or system managed (or whatever it's called) is a matter of dispute. My personal opinion is for uniformed sizing.
Mogens Prem Khanna J wrote: >Guys, > >The paper "How to stop defragmenting and start living" has >some SAFE rules for extent management in dictionary >managed tablespaces (in oracle 8 and 8i) as below: > >---------------------------------------------------------------------- >Segments smaller than 128M should be placed in 128K extent tablespaces. >Segments between 128M and 4G should be placed in 4M extent tablespaces. >Segments larger than 4G should be placed in 128M extent tablespaces >---------------------------------------------------------------------- > >In LMT (in 8i),as the paper says,SAFE rules are implemented internally. > >does it mean that,i can place objects/segments of any size in LMT in Oracle 9iR1 ? > OR >should i go for dictionary managed tablespaces with the above said storage guide >lines ? > >i am moving my DB from 8.1.6 (with all dictionary managed tablespaces) >to 9.0.1 (where it is LMT by default). >In such a case,which is advisable and what would you guys prefer to do ? > >Regards, >Jp. > >PS: my version of oracle is 9iR1/win2k. > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?Shift_JIS?B?TW9nZW5zIE4/cmdhYXJk?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
