RE: List of SQL involved in a transaction

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 3 Feb 2009 11:08:57 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F0B62FA00_at_AAPQMAILBX02V.proque.st>

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_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vishal Gupta Sent: Tuesday, February 03, 2009 10:59 AM To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 03 2009 - 10:08:57 CST