How to use TKPROF Utility?

Hi,

How to use TKPROF Utility and run the TKPROF Utility.

Please explain step by step procedure.

Thanks in advance.

Regards,
Iyyappan.M

http://docs.oracle.com/cd_database_g...4_str.htm#1018

Hi,

Now i am created the trace file names like

'dummy_ora_2539.trc' In which prompt i will run the TKPROF
Utility. Either $ prompt or sys or system.

tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = username/password TABLE = tablename
sys=no sort = (PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU)

Following syntax is correct or not.


Thanks in advance,

Regards,
Iyyappan....

hai you will have the tkprof exe in the bin folder.

so in the command prompt
c:\oraclehome\bin
give the command

tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = username/password TABLE = tablename
sys=no sort = (PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU)

Just do:

tkprof file.trc file.txt

Then read the file normally.

Cheers

Angel

Hi

As per request i have run the command in command prompt


tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = iyyappan/iyy table=spacemgm.spm_salstk
sys=no sort=(PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU)

I got following error: syntax error: `(' unexpected

I have run the command in /oracle_home/bin in solaris
env.

Expecting ur reply eagerly,

Thanks,
Iyyappan.M

I don't think you need the brackets round the sort options

Regards

Hi
As per request i have run the command in command prompt


tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = iyyappan/iyy table=spacemgm.spm_salstk
sys=no sort=(PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU)

The syntax is correct or not?

I got following error: syntax error: `(' unexpected

I have run the command in /oracle_home/bin in solaris
env.

Expecting ur reply eagerly,

Thanks,
Iyyappan.M

It looks like you've run the same statement, try:

tkprof dummy_ora_2539.trc dummy_ora_2539.prf
explain = username/password TABLE = tablename
sys=no sort =PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU

Regards

Here's a quick How-To:

http://www.oracle-base.com/Articles/...racleTrace.asp

Cheers

Hi Tim,

When i run the command in command prompt it will not accept. How to run TKPROF utility in command prompt(Solaris
environment)

tkprof dummy_ora_2539.trc dummy_ora_2539.prf explain=iyyappan/iyy table=spacemgm.spm_salstk sys=no
sort=PRSDSK,EXEDSK,FCHDSK,EXECPU,FCHCPU

The syntax is correct or not.

I have run the command in /ORACLE_HOME/admin/dummy/udump .

Mail me immediately regarding this,

Thanks in advance,

Regards,
Iyyappan.M

try
$ORACLE_HOME/bin/tkprof dummy....

hi,

I will try both udump and /oracle_home/bin also.

same error.

which error?