Share free Oracle DBA scripts and OS related shell scripts in this forum section. Very useful resource sharing for all DBAs and System administrators. Shell scripts, DBA scripts, SQL scripts, PL/SQL Packages, functions, triggers, windows dos scripts, sharing.
To find out which session is generating UNDO at present, kindly try with following script.
- Code: Select all
r.name "RBS name",
t.used_ublk "Undo blocks",
t.used_urec "Undo recs"
t.addr = s.taddr and
r.usn = t.xidusn;
- Posts: 34
- Joined: Sun Aug 28, 2011 5:39 am
Excellent script very useful. Thanks for sharing.
- Registered User
- Posts: 37
- Joined: Sat Aug 27, 2011 10:28 pm
Return to Free Oracle Scripts
Who is online
Users browsing this forum: No registered users and 1 guest