RE: Locally managed System Tablespace

From: Gene Sais <Gsais_at_co.palm-beach.fl.us>
Date: Tue, 07 Oct 2003 08:59:36 -0800
Message-ID: <F001.005D2479.20031007085936@fatcity.com>

Personally I agree w/ Dennis, If it works, don't mess w/ it. I am moving to LMT & Undo TBS when I upgrade to 9i from 8i. Gene

>>> DWILLIAMS_at_LIFETOUCH.COM 10/07/03 10:29AM >>> Thomas

   To me, the main benefits are in manageability. I feel in most circumstances the performance benefits will be small.

   As an approach, I have created all new tables in LMT with uniform extents
over the last several years. I have moved tables that grow steadily to LMT.
I have left a lot of older, static tables in dictionary-managed for the time
being, but overall that is probably under 5% of the storage. My theory is
don't mess with stuff that works.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, October 06, 2003 6:09 PM
To: Multiple recipients of list ORACLE-L

Is it really worth the effort to convert dictionary-managed system tablespaces to
locally-managed in 9.2? Ostensibly, I should see some performance improvements due
to less recursive sql, etc; but from Googling/Metalink in looking for more
info, it
doesn't appear as though many sites have bothered to convert.

The process is like this:

1. Convert all dictionary-managed to LMTs.
2. - cold backup
   • DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL
   • another cold backup

Seems as though it might be better to wait until 10G when I assume Oracle
will convert
to LMT as part of the migration process; unless anyone can offer some compelling reasons?

---

Jeffery D Thomas
DBA
Thomson Information Services
Thomson, Inc.

Email: jeff.thomas_at_thomson.net

Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Thomas Jeff
  INET: jeff.thomas_at_thomson.net

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

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

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). Received on Tue Oct 07 2003 - 11:59:36 CDT