From rafiq9857@hotmail.com Wed, 30 Jan 2002 09:29:43 -0800 From: "Mohammad Rafiq" Date: Wed, 30 Jan 2002 09:29:43 -0800 Subject: Re: ALTER ROLLBACK SEGMENT rbs SHRINK Message-ID: MIME-Version: 1.0 Content-Type: text/plain Yes, it can be shrinked below optimal as per following details specially R03 rollback segment.... Regards Rafiq before: NAME EXT MB OPTSIZE ACTIVE WATER SHRINKS WRAPS WAITS STATUS --------------- ---- ------- ------- ------- ------- ------- -------- ------ ------- SYSTEM 2 0.2 0.0 0.1 0 0 0 ONLINE R04 57 115.8 200 0.0 115.8 0 0 0 ONLINE R01 50 101.6 200 0.0 101.6 0 0 0 ONLINE R02 50 101.6 200 0.0 101.6 0 0 0 ONLINE R03 99 201.1 200 0.0 201.1 0 0 0 ONLINE ---- run script: SQL> alter rollback segment r03 shrink to 100M; After: NAME EXT MB OPTSIZE ACTIVE WATER SHRINKS WRAPS WAITS STATUS --------------- ---- ------- ------- ------- ------- ------- -------- ------ ------- SYSTEM 2 0.2 0.0 0.1 0 0 0 ONLINE R04 57 115.8 200 0.0 115.8 0 0 0 ONLINE R01 50 101.6 200 0.0 101.6 0 0 0 ONLINE R02 50 101.6 200 0.0 101.6 0 0 0 ONLINE R03 50 101.6 200 0.0 201.1 5 0 0 ONLINE Reply-To: ORACLE-L@fatcity.com To: Multiple recipients of list ORACLE-L Date: Wed, 30 Jan 2002 07:25:30 -0800 no, you can't shrink a rollback segment below the optimal value --- Sinard Xing wrote: > Hi, > > > Assume > INITIAL * MINEXTENT = 2M and also = OPTIMAL > > Do you think > ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M; > > will work ? > > > > Thanks, > > Sinardy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinard Xing > INET: sinardyxing@bcs-ach.com.sg > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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). __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). MOHAMMAD RAFIQ _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: rafiq9857@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).