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  
v$lock.ctime 
   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?
>
>
>--
>//www.freelists.org/webpage/oracle-l
>
>.


        


--
//www.freelists.org/webpage/oracle-l

Other related posts: