RE: tkprof question
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <larry.j.lutz@xxxxxxxxx>, <nirmalya@xxxxxxx>
- Date: Fri, 19 May 2006 14:54:04 -0500
10046 Trace levels
4 - BINDs
8 - waits
2 - combines levels 4 and 8 (binds and waits)
Ric Van Dyke
Hotsos Enterprises
Cell 248-705-0624
-----------------------
Hotsos Symposium March 4-8, 2007. Be there.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Larry Lutz
Sent: Friday, May 19, 2006 2:31 PM
To: nirmalya@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: tkprof question
I think only "level 12 traces" produce wait events output.
On 5/19/06, Nirmalya Das <nirmalya@xxxxxxx > wrote:
I want to see the "wait events" along with my cost for a particular
query.
My environment:
Sun Solaris (SUNOS 5.9)
Oracle 9.2.0.7
TIMED_STATISTICS is not set in the parameter file....
So, I am doing
SQL> alter session set sql_trace=true;
SQL> alter session set timed_statistics=true;
SQL> "running the SQL here"
After getting the trace:
$ tkprof <trace file> <output file> explain=... sys=no waits=yes
But the "output file" never produces the "wait events"
Any ideas?
TIA
Nirmalya
--
//www.freelists.org/webpage/oracle-l
--
" ,--o
-\\_<_
(*)/-'(*)
Other related posts:
