Category Archives: Script
Viewing Who’s Using Transaction Undo / Rollback Segment
Here is a script to identify the active transaction are currently using rollback segments or undo segments. Conditions, log into the database as user SYS or SYSTEM or a user who has been in the grant DBA. col o format … Continue reading
Posted in Script
Tagged addr, blinklist, blogmarks, col, Conditions, database, DBA, digg, Draft, format a8, google, grant, netvouz, order, Rollback, rollback segment, rollback segments, script, Segment, segment name, space, SYS, System, technorati, time, time format, Transaction, txt, Undo, user, username, username format, Viewing, xidusn, YES
Leave a comment