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