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