On Wed, 23 Jul 2003, zhu chao wrote:
> Hi, guang: > I have two questions: > 1. Why create rbs on lmt tablespace and later drop it again? Just do > step 1-7 and it is ok. Or maybe you need to update your init file, but you > can also offline old rbs01 and create new rbs01 on lmt, and so on. You are right that I only need to create rbs01 on lmt ts once, and that was how I did it (see my other post). > > 2. If you have dmt rollback segment in production and you did create the > rbs with(initial=next, min=20), in most case , rbs won't expand or > shrink.And the convertion does not help much . right? > I set storage(initial 2048K next 2048K minextents 2 ) for all my rbs. So there will be expand or shrink in RBS tablespace. I think that convert to LMT would reduce space management operation in data dictionary, therefore help the performance. However, I have never done any measurements of how much improvement one could get by converting RBS tablespace from DMT to LMT. Guang > Regards > zhu chao > msn:[EMAIL PROTECTED] > www.cnoug.org > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, July 24, 2003 2:14 AM > > > > Do I need to? I thought after all the steps I still have the same rollback > > segment names (RBS01-06). The only difference is they will be in LMT now. > > > > Guang > > > > -----Original Message----- > > DENNIS WILLIAMS > > Sent: Wednesday, July 23, 2003 1:35 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Guang - Don't forget to update your init.ora! > > > > Dennis Williams > > DBA, 80%OCP, 100% DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -----Original Message----- > > Sent: Wednesday, July 23, 2003 12:24 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi: > > > > I need to convert RBS tablespace (used for rollback segments) from DMT to > > LMT on a 24x7 production machine (Solaris 2.8, Oracle 8173). Here are the > > steps I am thinking of taking: > > > > 1. create a new rbslmt tablespace > > > > 2. create new rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) in > > rbslmt ts , set them online > > > > 3. alter all old rollback segments (RBS01, ... RBS06) offline; > > > > 4. Drop all old rollback segments; > > > > 5. alter old RBS tablespace offline > > > > 6. Drop old RBS tablespace > > > > 7. Remove old RBS tablespace's datafiles from OS > > > > 8. Create new RBS tablespace as LMT > > > > 9. Create new rollback segments (RBS01, ... RBS06) in RBS, set them > online; > > > > 10. alter rollback segments (RBSlmt01, RBSlmt02, ... RBSlmt 06) offline, > > then drop them; > > > > 11. alter tablespace rbslmt offline > > > > 12. drop tablespace rbslmt > > > > 13. Remove tablespace rbslmt's datafiles from OS. > > > > Anything I am missing? > > > > TIA. > > > > Guang > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Guang Mei > > 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: Guang Mei > > 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: zhu chao > 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: Guang Mei 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).