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
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.