11-11
Copyright Ó Oracle Corporation, 1999. All rights reserved.
Diagnosing Rollback Segment Contention
SQL> select value from v$sysstat
2 where name = 'consistent gets';
VALUE
----------
71563
The
number of waits for any class
should be less than 1% of the total number of requests.
If
not, create more rollback segments.