+ Reply to Thread
Results 1 to 6 of 6
  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 »

Bookmarks

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