RE: Locally managed System Tablespace

From: Thomas Jeff <jeff.thomas_at_thomson.net>
Date: Tue, 07 Oct 2003 08:04:25 -0800
Message-ID: <F001.005D2470.20031007080425@fatcity.com>

Thanks for the reply Dennis. I don't think my question was very clear -- I was specifically asking about the SYSTEM tablespace only -- whether it was worth the effort to convert it to LMT.

-----Original Message-----
Sent: Tuesday, October 07, 2003 9:29 AM
To: Multiple recipients of list ORACLE-L

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