TKPROF and wait events?

Printable View

07-23-2004, 08:05 AM
efrijters

TKPROF and wait events?

Hello,

I'm reading "Effective Oracle by Design" by Thomas Kyte. Chapter 8 (page 449-451) shows a test with db_file_multiblock_read_count. Tom prooves his theory with tkprof-output (event 10046 trace name context forever level 12).
The output also shows the encountered wait-events.

I tested it, but wait-events aren't in my output. According to the documentation this probably isn't present in this version (8.1.7). I looked at the doc's of 9i rel2 and I couldn't find it either.

How can I get wait-events displayed in my tkprof-output?

Thanks in advance,
Erik
07-23-2004, 08:16 AM
DaPi

Try using Trace Analyser:

ftp://oracle-ftp.oracle.com/apps/pat...MANCE/TRCA.zip

Quote:

Trace Analyzer compared to TKPROF
Recent Releases of TKPROF provide a limited list of WAIT EVENTs per SQL Statement. Prior Releases did not provide any. The Trace Analyzer provides a detailed list of WAIT EVENTs per SQL Statement for any Release of RDBMS higher than 8.1.6.

. . .or make sure you have the v.latest tkprof.
07-23-2004, 08:18 AM
efrijters

Thanks a lot DaPi!
07-23-2004, 08:37 AM
efrijters

Okay... who removed the trca.zip from the oracle-site? ...well?

[edit]
Got it...
[/edit]
07-23-2004, 09:05 AM
DaPi

The Oracle sites have been sick the last few hours - Meatlink wasn't etc etc.
07-23-2004, 09:22 AM
efrijters

They probably have problems with the database behind the site.... :D
07-23-2004, 09:47 AM
efrijters

Yeah! Trace Analyzer works great!!

Thanks DaPi!