RE: List of SQL involved in a transaction

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: "vishal@xxxxxxxxxxxxxxx" <vishal@xxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 3 Feb 2009 11:08:57 -0500

Unless you enable SQL_TRACE, or some form of auditing before the transaction, I 
don't believe there's any way to track it.

-Mark

--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Vishal Gupta
Sent: Tuesday, February 03, 2009 10:59 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: List of SQL involved in a transaction

Hi,

Does anyone know how to find list of all the SQLs involved in a transaction?

Regards,
Vishal Gupta
http://www.vishalgupta.com

Other related posts: