-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|