+ Reply to Thread
Results 1 to 7 of 7
  1. 07-23-2004 08:05 AM #1
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317

    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.
    Reply With Quote Reply With Quote
  2. 07-23-2004 08:16 AM #2
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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.
    Reply With Quote Reply With Quote
  3. 07-23-2004 08:18 AM #3
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Thanks a lot DaPi!
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
    Reply With Quote Reply With Quote
  4. 07-23-2004 08:37 AM #4
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    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.
    Reply With Quote Reply With Quote
  5. 07-23-2004 09:05 AM #5
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    The Oracle sites have been sick the last few hours - Meatlink wasn't etc etc.
    Reply With Quote Reply With Quote
  6. 07-23-2004 09:22 AM #6
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    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.
    Reply With Quote Reply With Quote
  7. 07-23-2004 09:47 AM #7
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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