1* select usn,gets,waits,writes from v$rollstat
QL> /

USN GETS WAITS WRITES
--------- ---------- ---------- ----------
0 263 0 3004
2 5455 1 3743980
3 8222 6 5453608
4 6931 2 2968946
5 6543 2 4224714
6 17841 0 3507384
7 5305 1 3898786
8 5749 0 3920966

No, The queries dont use specific rollback segments.


Thanks
Anurag