(Easy? ) Rollback segment - response

From: <scheuric_at_sprynet.com>
Date: 1997/03/25
Message-ID: <5h982a$bc2@lal.interserv.com>#1/1

You can determine if you need more rollback segments by looking at the ratio between waits and gets in the v$rollstat table. Another place to look is in the init.ora parameter. How many transactions are allotted to each rollback segment based on the number of users in the system?

-Sheilah Scheurich
DBA Received on Tue Mar 25 1997 - 00:00:00 CST