DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: parsing a 10046 event trace file

Threaded View

  1. #3
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    No... Tkprof output still have p1, p2, p3..

    I am sure someone out there has a little perl script that can parse the entire script for p1, and p2 and run this query and format the output for waiting object name and type:

    SELECT owner , segment_name , segment_type
    FROM dba_extents
    WHERE file_id = &AFN
    AND &BLOCKNO BETWEEN block_id AND block_id + blocks -1;
    Last edited by newbie5; 04-15-2004 at 05:49 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width