Re: How to identify large transactions

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_at_hotmail.com
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?
  >
  >
  >--
  >http://www.freelists.org/webpage/oracle-l
  >
  >.
  

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