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

Thread: how to start tkprof

  1. 08-21-2002, 05:17 AM #1
    Daflow
    Daflow is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 08-21-2002, 06:57 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  3. 08-21-2002, 07:09 AM #3
    Daflow
    Daflow is offline Junior Member
    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
    Reply With Quote Reply With Quote
  4. 08-21-2002, 07:41 AM #4
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  5. 08-21-2002, 08:31 AM #5
    Daflow
    Daflow is offline Junior Member
    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
    Reply With Quote Reply With Quote
  6. 08-21-2002, 09:03 AM #6
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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