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 <jprem_at_kssnet.co.jp> 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: jprem_at_kssnet.co.jp
>
> 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: ListGuru_at_fatcity.com (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: connor_mcdonald_at_yahoo.com
"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
Received on Wed Mar 19 2003 - 03:38:16 CST