RE: List of SQL involved in a transaction
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "vishal@xxxxxxxxxxxxxxx" <vishal@xxxxxxxxxxxxxxx>, "cary.millsap@xxxxxxxxxxxx" <cary.millsap@xxxxxxxxxxxx>
- Date: Tue, 3 Feb 2009 12:16:40 -0500
Right, what you're asking isn't possible. It's simply not available in the the
V$ (or X$) views. The V$ and X$ views are mapped to memory in the SGA and
represent what's happening *right now*. Once a statement has finished
executing, it's still in the shared pool, but it's no longer associated with
any session or transaction.
-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 12:10 PM
To: cary.millsap@xxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: List of SQL involved in a transaction
yes trace is one of the way. But then there could be lot of transactions in a
session. I was more interested in finding information from v$ or x$ views.
Say, you have session blocking another session. And you can find out what
objects are locked by blocking session and identify the session as well. But
one wanted to find out all the SQL statements already executed by this blocking
session in current transaction, how do you generate this list. V$TRANSACTION
gives information about current SQL_ID and pre_sql_id. But not all of them.
Regards,
Vishal Gupta
http://www.vishalgupta.com
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Cary Millsap
Sent: Tue 03/02/2009 16:07
To: Vishal Gupta
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: List of SQL involved in a transaction
dbms_monitor.session_trace_enable
Cary
On Tue, Feb 3, 2009 at 9:59 AM, Vishal Gupta
<vishal@xxxxxxxxxxxxxxx<mailto:vishal@xxxxxxxxxxxxxxx>> wrote:
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:
