Re: convert RBS tablespace from DMT to LMT (Oracle 8173) steps?

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:chao_ping_at_163.com
> www.cnoug.org
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> 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.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----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: gmei_at_incyte.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: 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: Guang Mei
> > INET: gmei_at_incyte.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: zhu chao
> INET: chao_ping_at_vip.163.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
Received on Wed Jul 23 2003 - 21:43:07 CDT