Re: How to identify large transactions

  • From: "biti_rainy" <biti_rainy@xxxxxxxxx>
  • To: "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 5 Jan 2005 20:34:48 +0800

hi,John Dunn

   you can query the  v$transaction:  start time /used  blocks   , or  
   and you can join  v$transaction.addr to  v$session.paddr ,find out the  
hash_value    and  sql address ,then join to v$sqlarea(v$sqltext).

Best regards

msn: biti_rainy@xxxxxxxxxxx
a dba from alibaba(china)

---- from the  mail-----
>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: