Opps, that should be 12 - 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 Ric Van Dyke Sent: Friday, May 19, 2006 3:54 PM To: larry.j.lutz@xxxxxxxxx; nirmalya@xxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: tkprof question 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 -\\_<_ (*)/-'(*)