📋Steps in this guide1/1

Find sessions generating undo

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 ;

oracle configurationintermediate

by OracleDba

12 views

Find sessions generating undo

Code/Command (click line numbers to comment):

1
2
3

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 ;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!