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

Thread: TKPROF Utility... Utilization.

  1. #1
    Join Date
    Feb 2001
    Posts
    184

    Thumbs up

    Hi Guys,

    Can any one please elaborate the quick and easy method of using TKPROF Utility.

    I don't know much about this but I know that I have to issue Alter Session set SQL_Trace = True, But how to do that on database level and where will I see that Trace and How to use that...

    Please explain me in Details... Step by Step.
    Any help greatly appreciated.
    Thanks...

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    To enable tracing on instance level you have to set the init parameter SQL_TRACE=TRUE and restart the database (I'm not sure, maybe in new releases this parameter can be set dynamically, without bouncing the database).

    Once this parameter is set each session will begin to write its own trace file in your USER_DUMP_DESTINATION directory. You can then analyze each of those trace files with TKPROF individually, or you can concatenate them into one large file and run TKPROF on it.

    Oracle Tuning manual will give you more details....

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Feb 2001
    Posts
    184
    Thanks Jmodic,

    How would I use that SQL Tracing with TKPROF... That's what I need to know.

    Can you please elaborate more. Anyother feedback also appreciated.

    Thanks.

  4. #4
    Join Date
    Nov 2000
    Posts
    224
    SQL_TRACE=TRUE will start generating the output in Trace file in user dump. TKPROF is a OS utility and will convert the output in a readable format. You can go through the the report (Text file) generated by TKPROF.

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