-
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
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
-
Try using Trace Analyser:
ftp://oracle-ftp.oracle.com/apps/pat...MANCE/TRCA.zip
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.
-
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
-
Okay... who removed the trca.zip from the oracle-site? ...well?
[edit]
Got it...
[/edit]
Last edited by efrijters; 07-23-2004 at 09:03 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
-
The Oracle sites have been sick the last few hours - Meatlink wasn't etc etc.
-
They probably have problems with the database behind the site....
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
-
Yeah! Trace Analyzer works great!!
Thanks DaPi!
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|