Treat dictionary managed tablespaces as being obsolete. Use LMT's for everything.
On an unrelated note, if you can, go for 9.2 not 9.0, its streets ahead. hth connor --- Prem Khanna J <[EMAIL PROTECTED]> 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: Prem Khanna J > 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). > ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
