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

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
Received on Wed May 01 2002 - 09:49:49 CDT