RE: List of SQL involved in a transaction
- From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Tue, 3 Feb 2009 17:30:36 -0000
I want to identify all the SQL statement that a blocking session has executed
in current transaction, so that I can give that list to application team.
I guess log mining is the only option available.
Regards,
Vishal Gupta
http://www.vishalgupta.com
________________________________
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Tue 03/02/2009 17:16
To: Vishal Gupta
Cc: cary.millsap@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: List of SQL involved in a transaction
On Tue, Feb 3, 2009 at 9:10 AM, Vishal Gupta <vishal@xxxxxxxxxxxxxxx> wrote:
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.
What you asked for was all the SQL in a transaction.
Perhaps you could state your actual goal?
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
