Hi Friends..

I issued the following sql :

select gets,waits,waits/gets*100 wait_ratio,'%'
from v$rollstat

The results were :


GETS WAITS WAIT_RATIO '
---------- ---------- ---------- -
898 0 0 %
21800 0 0 %
20550 0 0 %
19363 0 0 %
18700 0 0 %
20153 0 0 %
18809 0 0 %
20080 0 0 %
19423 0 0 %
18899 0 0 %
21022 0 0 %

GETS WAITS WAIT_RATIO '
---------- ---------- ---------- -
20640 1 .004844961 %
19875 0 0 %
20053 0 0 %
19873 0 0 %
19588 0 0 %
20170 0 0 %
21167 1 .004724335 %
19917 0 0 %
20122 0 0 %
19503 0 0 %
19346 0 0 %

GETS WAITS WAIT_RATIO '
---------- ---------- ---------- -
19476 0 0 %
20348 0 0 %
21198 0 0 %


2 rollback segments have had a wait.
does this mean that I should consider adding another rollback segment or 2 ?

Thanks in advance
Suresh