Re: rollback segment waits

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: 2000/09/20
Message-ID: <39c897dc.554206807@nsw.nnrp.telstra.net>#1/1

Hello Maran,

Have a look at the script enough_rollback_segs.sql at http://www.ixora.com.au/scripts/rbs.htm#enough_rollback_segs. This script can distinguish between read and write waits. Write waits normally respond to an increase in the number of rollback segments. For read waits you need to get a bit more sophisticated.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
@
@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: ilamaran_at_my-deja.com

HI
In production database the first day the rollback segment waits is 24 then i increase the number of rollback segments, and applied set transaction use rollback segments(new). But still its waits increases. I made it offline for some time, again it says the same waits about 32.

any body give idea about increasing the waits in rollback segments. How to avoid this?
Maran

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 20 2000 - 00:00:00 CDT