Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

List of undo records for a transaction

Krystian RFeb 19 2020 — edited Feb 21 2020

Hi,

I'm investigating a performance issue on my database. What I found out, that a session (lasting for a day) has a lot of undo blocks/records user. I used the following query to identify the session:

select t.start_time,s.sid,s.serial#,s.username,s.status,s.schemaname, t.USED_UBLK "undo blocks used" , t.USED_UREC "undo records used",

s.osuser,s.process,s.machine,s.terminal,s.program,s.module,to_char(s.logon_time,'DD/MON/YY HH24:MI:SS') logon_time

from v$transaction t, v$session s

where s.saddr = t.ses_addr

order by start_time;

Is there a way to list of undo records for a particular transaction (and if possible, to what database block they apply)?

thanks,

Krystian

This post has been answered by Jonathan Lewis on Feb 19 2020
Jump to Answer
Comments
Post Details
Added on Feb 19 2020
13 comments
2,728 views