| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rollback Segment Shrinkage Question
nope, it doesn't. Oracle only checks the size of the rollback against
optimal when you need to move from one extent within the rollback segment to
another.
You are right that when it shrinks automatically it can have a performance hit but that's usually minimal. What's important to check is to see if your rollback segments are extending and shrinking constantly. If they are, you have sized them and/or the optimal parameter incorrectly.
>From: "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Rollback Segment Shrinkage Question
>Date: Tue, 17 Oct 2000 08:25:54 -0800
>
>I think after the transaction completes it will shrink back to optimal.
>Keep
>in mind their is a performance
>hit and you should monitor the frequency of dynamic extensions.
>
>Rick
>
> > -----Original Message-----
> > From: Carle, William T (Bill), NBSO [SMTP:wcarle_at_att.com]
> > Sent: Tuesday, October 17, 2000 10:21 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Rollback Segment Shrinkage Question
> >
> > Hi,
> >
> > At what point in time does a rollback segment shrink back to its
> > optimal
> > value?
> >
> >
> > Bill Carle
> > AT&T
> > Database Administrator
> > 816-995-3922
> > wcarle_at_att.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Carle, William T (Bill), NBSO
> > INET: wcarle_at_att.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_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.com
>--
>Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.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_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).
Share information about yourself, create your own public profile at Received on Tue Oct 17 2000 - 17:51:29 CDT
 |
 |