Re: Tracing a single SQL statement

From: Dion Cho <ukja.dion_at_gmail.com>
Date: Tue, 2 Mar 2010 13:06:38 +0900
Message-ID: <43c2e3d61003012006w2490bdb1ufa223cf4824bc925_at_mail.gmail.com>

As far as I know, the SQL statement level trace is only available as of 11g.

http://oraclue.com/2009/03/20/oracle-diagnostic-events-part-4/ http://oraclue.com/2009/03/24/oracle-event-sql_trace-in-11g/

For instance,

alter system set events 'trace[sql_costing][sql:<sql_id_here>]'; -- 10053 alter system set events 'sql_trace[sql:<sql_id_here>]'; -- 10046

But in 10g and lower, the lowest level of the diagnostic event is the SESSION.

---

Dion Cho - Oracle Performance Storyteller

http://dioncho.wordpress.com (english)
http://ukja.tistory.com (korean)
http://dioncho.blogspot.com (japanese)
http://ask.ex-em.com (q&a)
================================

2010/3/2 Rich <richa03_at_gmail.com>

> Hi all,
>
> This is 64-bit 10.2.0.4 on RHEL 5.1 (kernel 2.6.18-53).
>
> Is there any way to set 10046 and/or 10053 tracing on for a single SQL
> statement in another session without access to the SQL code?
>
> Thanks,
> Rich
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 01 2010 - 22:06:38 CST