How can i get this wait event from the trace file

From: chao_ping <chao_ping_at_163.com>
Date: 1 May 2002 06:13:58 GMT
Message-ID: <3ccf87a6$1@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 - 01:13:58 CDT