RE: Locally managed System Tablespace
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. [EMAIL PROTECTED] -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: a) Convert all dictionary-managed to LMTs. b) - 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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).
RE: Locally managed System Tablespace
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. [EMAIL PROTECTED] -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: a) Convert all dictionary-managed to LMTs. b) - 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Jeff 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).
RE: Locally managed System Tablespace
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 [EMAIL PROTECTED] 10/07/03 10:29AM Thomas To me, the main benefits are in manageability. I feel in mostcircumstances the performance benefits will be small. As an approach, I have created all new tables in LMT with uniform extentsover 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 timebeing, but overall that is probably under 5% of the storage. My theory isdon't mess with stuff that works.Dennis WilliamsDBA, 80%OCP, 100% DBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Monday, October 06, 2003 6:09 PMTo: Multiple recipients of list ORACLE-LIs it really worth the effort to convert dictionary-managed systemtablespaces to locally-managed in 9.2? Ostensibly, I should see some performanceimprovements due to less recursive sql, etc; but from Googling/Metalink in looking for moreinfo, it doesn't appear as though many sites have bothered to convert.The process is like this:a) Convert all dictionary-managed to LMTs.b) - cold backup - DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL - another cold backupSeems as though it might be better to wait until 10G when I assume Oraclewill convert to LMT as part of the migration process; unless anyone can offer somecompelling reasons?Jeffery D ThomasDBAThomson Information ServicesThomson, Inc.Email: [EMAIL PROTECTED]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: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Locally managed System Tablespace
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. [EMAIL PROTECTED] -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. [EMAIL PROTECTED] -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: a) Convert all dictionary-managed to LMTs. b) - 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: [EMAIL PROTECTED] 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: [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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Jeff 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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).
