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).
