Re: How can i get this wait event from the trace file

I think the question may be how to get the wait reported in the tkprof output after you've got them in the trace file.

To which the answer is:

    It was an Oracle 6 feature that disappeared     from 7 and 8, and has just come back in 9.

tkprof trc_file prf_file waits=yes

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Author of:
Practical Oracle 8i: Building Efficient Databases

Next Seminar - Australia - July/August
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html



Chuck wrote in message ...


>Therese was a presentation on this at IOUG 2002 about two weeks ago. Tway

to


>include wait info in a trace file is by setting  an event. Here are the

>notes a jotted down about it...

>

>System event 10046

>. Set with: instance parameter (does entire instance) , alter session,

>oradebug, dbms_system.set_ev (can set . event for other sessions).

>. Alter session set events '10446 trace name context forever, level n

>. 1= ordinary sql trace

>. 4=trace with bind vars

>. 8=trace with wait event info

>. 12=8 + 4

>. Use raw trace file to see bind and wait info. Tkprof won't show them.

>

>Can't remember the presenters name but I also jotted down his web address.

I


>think you can find the entire presentation somewhere on the site.

>http://www.dbspecialists.com

>

>

>"chao_ping" <chao_ping_at_163.com> wrote in message

>news:3ccf87a6$1_at_usenetgateway.com...

>> Look at link: http://asktom.oracle.com/pls/ask/f?p=4950:8:753621::NO::F-

>> 4950_P8_DISPLAYID,F4950_P8_CRITERIA:920429344869,%7Btrace%7D%20and%20%7-

>> Balter%7D%20and%20%7Bsession%7D

>>

>> Search for keyword: "Edgars" and you will see:

>>

>> Elapsed times include waiting on following events: Event waited on Times

>> Max. Wait Total Waited ---------------------------------------- Waited

>> ---------- ------------ SQL*Net message to client 2 0.00 0.00 SQL*Net

>> message from client 2 0.00 0.00

>> **********************************************************************-

>> **********

>> It seems that he get the report from tkprof. But how did he make it? To

>> trace the session with wait event, maybe we can use dbms_support or

>> alter session set event to do this, but tkprof document help doesnot

>> analyze the wait event. How did he make it? any one knows ? thanks.

>>

>>

>>

>> --

>> an oracle fan,

>> an oracle beginner

>>

>> Posted via dBforums

>> http://dbforums.com

>

>