Oracle-L: RE: Locally managed System Tablespace

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 07 Oct 2003 09:24:25 -0800
Message-ID: <F001.005D247A.20031007092425@fatcity.com>

Jeff - Sorry, too many issues flying here lately, not reading carefully. Myself, I would be reluctant to convert the system tablespace. The possibilities would keep me awake at night, already got enough of that. Ideally (in my mind), you will have the opportunity to move to 9i or 10i by export/import the data.

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

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

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:

Convert all dictionary-managed to LMTs.
- 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
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------