Re: List of SQL involved in a transaction
- From: Jared Still <jkstill@xxxxxxxxx>
- To: vishal@xxxxxxxxxxxxxxx
- Date: Tue, 3 Feb 2009 09:16:49 -0800
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:
