[10.2.0.1 on W2K3] Waiting events in TKPROF report
Hi,
I activated a trace on a particular session.
Then I produced the TKPROF report.
The TKPROF report shows an important waiting time at the end in the part : "Elapsed times include waiting on following events"
But I'm unable to find a query in my report with a such important waiting time.
How could I find the cause of that waiting time ?
Please find below my TKPROF report.
Regards,
Frederic
TKPROF: Release 10.2.0.1.0 - Production on Mar. Déc. 7 16:34:50 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Trace file: pam_ora_5016.trc
Sort options: exeela fchela prsela
********************************************************************************
count = number of times OCI procedure was executed
Then I produced the TKPROF report.
The TKPROF report shows an important waiting time at the end in the part : "Elapsed times include waiting on following events"
But I'm unable to find a query in my report with a such important waiting time.
How could I find the cause of that waiting time ?
Please find below my TKPROF report.
Regards,
Frederic
TKPROF: Release 10.2.0.1.0 - Production on Mar. Déc. 7 16:34:50 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Trace file: pam_ora_5016.trc
Sort options: exeela fchela prsela
********************************************************************************
count = number of times OCI procedure was executed
0