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

Thread: Invoking TKPROF UTILITY!!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Query!

    1.What is the command to invoke TKPROF in Oracle v8i and
    OS as NT.In this view,what other parameters are to be taken into consideration!

    2.We created a new DB and after that we tried to run the Package UTL_FILE but it failed!

    What could have gone wrong!

    Regards,

    Amitst.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. tkprof
    Jeff Hunter

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    If you have the trace file xxx.trc, say, in the c:\junk\ directory then TKPROF works as follows:

    In c:\junk\ type TKPROF xxx.trc aaa.txt

    Then open aaa.txt in Notepad and check the statistics.




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