Re: Question on Rollback Segments

Chris,

In short, the answer is "No." If you are experiencing performance problems, the OPTIMAL setting on your rbs is not really on the list of first things to check. You should check out stuff like the buffer cache hit ratio, the library cache, dictionary cache, io distribution, etc.

And don't forget to look at the sql that your users are actually executing.

The "OPTIMAL" setting on rbs is there really as a space mgmt thing rather than a performance thing.

Regards,
Charles_Dye_at_corp.dialog.com

> From owner-oracle-l_at_CCVM.SUNYSB.EDU Wed Jan 17 06:31:01 1996
> Date: Wed, 17 Jan 1996 08:55:02 -0600
> From: "Christopher D. Larson" <Christopher.D.Larson_at_CDC.COM>
> Subject: Question on Rollback Segments
> X-To: oracle-l_at_ccvm.sunysb.edu
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_ccvm.sunysb.edu>
>
> I am currently running a 3gig DB with 10 non-system rollback segments
> created without the OPTIMAL option. Each segment has an initial 240k and
> next of 240k with 121 possible extents.
>
> Recently I have been getting complaints regarding performance. It is to my
> understanding that the OPTIMAL setting will allow deallocation of extents on
> your rollback segments as well as improve performance.
>
> My question is basically this:
> Is this performance improvment visable by the naked eye?
>
> TIA!
>
> Chris Larson
> Oracle DBA
> Control Data Systems
> Christopher.D.Larson_at_cdc.com
>
Received on Wed Jan 17 1996 - 12:56:33 CST