Re: How to identify large transactions

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <Oracle-L@xxxxxxxxxxxxx>
  • Date: Tue, 4 Jan 2005 15:06:44 -0000

Look at v$transaction -
    used_ublk, used_urec    undo blocks and records used
for updates that are not array-based, each
record is roughly equivalent to one change
to a table or index block.  For example,
if you update one row, changing non-null columns
that are in three indexes, you will get 7 undo
    One for the table, two for each index.

The view also has
to tell you when the transaction started, and
to get you back to the owning session (v$session.saddr)


Jonathan Lewis
The Co-operative Oracle Users' FAQ
Public Appearances - schedule updated Dec 23rd 2004

----- Original Message ----- 
From: "John Dunn" <jdunn@xxxxxxxxx>
To: <Oracle-L@xxxxxxxxxxxxx>
Sent: Tuesday, January 04, 2005 1:08 PM
Subject: How to identify large transactions

I believe that some developers sql is generating large transactions possibly
due to lack of commit statements.

How can I identify these large transactions and the sql responsible?



Other related posts: