Home / DATABASE SCRIPTS / How to find the session using lot of undo How to find the session using lot of undo 11169 views Less than a minute 2 Below query will show the current sessions undo usage. select a.sid, a.serial#, a.username, b.used_urec used_undo_record, b.used_ublk used_undo_blocks from v$session a, v$transaction b where a.saddr=b.ses_addr ;