how to start tkprof
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: how to start tkprof

  1. #1
    Join Date
    May 2002
    Posts
    11
    Hello,

    i want to use the tkprof utility but i canīt find it? I think this toll has to be started in the system enviroment and not in sql plus?

    Thanks


    FLO

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The tkprof utility is not part of sqlplus, it needs to be started as a seperate application. It is typically located in $ORACLE_HOME/bin

    Regards

    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    May 2002
    Posts
    11

    Unhappy

    Hello Jovery,

    i canīt find tkprof in any directory of my oracle! Is it possible that it is only available in UNIX?

    Thanks

    FLO

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    No tkpof is available in all platforms (I've got it on Linux, Sun & NT) I think.

    In each case it's in $ORACLE_HOME/bin, does your path statement include the above?

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  5. #5
    Join Date
    May 2002
    Posts
    11

    Unhappy

    Hello jovery,

    i work with oracle 9i my path is oracle\ora90\bin... i think. there are a lot of stuff but no tkprof??? is it possible that i have missed to install it?

    FLO

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Hi,

    There was a bug in 9.0.1 which meant that tkprof was not installed, you need to download and install patchset 9.0.1.2 or you can copy the executable from and 8.1.7 version if you have it.

    This metalink note explains the bug:
    http://support.oracle.co.uk/metalink..._id=175812.995

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

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