rollback segment question

From: <kal121_at_yahoo.com>
Date: Wed, 08 Dec 1999 17:10:27 GMT
Message-ID: <82m3dt$efc$1@nnrp1.deja.com>

I've heard differing opinions on rollback segments:

Everyday our system seems to have more "waits" on the rollback segments, however the ratio of waits to gets is well under 1%. For example, yesterday we had a total of 52 rbs waits, today there is 77. Does this mean I should keep adding rollback segments - or not worry about is since the "get ratio" is still greater than 99%? There are 20 rollback segs currently. I'd like an solid opinion on this.

Also, how can I measure the number of transactions being performed on the database for a given time period? I'd really like to know how to measure this!

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 08 1999 - 11:10:27 CST