how to start tkprof

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

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

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

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

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

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