RE: List of SQL involved in a transaction

From: Barun, Vlado <Vlado.Barun_at_JTV.com>
Date: Wed, 11 Feb 2009 21:12:20 -0500
Message-ID: <0181A069127F1944B484ED5B858D0C160C0EA9BFAA_at_KPMSPW02.jewelry.acn>

Well, if trace is not an option, you might want to try dba_hist_active_sess_history (assuming you have the necessary license). Please be aware that this view might not give you a complete list of sql_id executed in a session if you have queries that complete it < 1 second.

Regards,

Vlado Barun, M.Sc.
Sr. Manager, Database Engineering and Operations Jewelry Television
Email: vlado.barun_at_jtv.com

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vishal Gupta Sent: Tuesday, February 03, 2009 12:10 PM To: cary.millsap_at_method-r.com
Cc: oracle-l_at_freelists.org
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_at_freelists.org on behalf of Cary Millsap Sent: Tue 03/02/2009 16:07
To: Vishal Gupta
Cc: oracle-l_at_freelists.org
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_at_vishalgupta.com<mailto:vishal_at_vishalgupta.com>> wrote: 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 Wed Feb 11 2009 - 20:12:20 CST