RE: Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

Google to the rescue... just one of the many links:

http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm

-Joe

At 02:10 PM 1/2/02 -0800, you wrote:
>Arul - I would recommend reading "How to Stop Defragmenting and Start
>Living: The Definitive Word on Fragmentation" by Bhaskar Himatsingka, an
>Oracle white paper. I was going to provide a link to it, but Oracle's
>website search function doesn't seem to work for me right now.
>Dennis Williams
>DBA
>Lifetouch, Inc.
>dwilliams_at_lifetouch.com
>
>
>
>
>-----Original Message-----
>Sent: Wednesday, January 02, 2002 12:10 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi DBAs,
>
>I would like to know on what basis we arrive at the decision of making a
>tablespace as LOCALLY Managed / DICTIONARY Managed...
>
>Any Suggestions / Tips....
>
>Thank you..
>
>Arul.
>
>*********************************************************
>Disclaimer
>
>This message (including any attachments) contains
>confidential information intended for a specific
>individual and purpose, and is protected by law.
>If you are not the intended recipient, you should
>delete this message and are hereby notified that
>any disclosure, copying, or distribution of this
>message, or the taking of any action based on it,
>is strictly prohibited.
>
>*********************************************************
>Visit us at http://www.mahindrabt.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Arul kumar
> INET: rakumar_at_mahindrabt.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Raube
  INET: joe_at_fullmoondba.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).