TKPROF--urgent !!!!!!!!!!!!!!!!!! [message #51570] |
Fri, 31 May 2002 03:48 |
LAKSHMI NARAYANA
Messages: 12 Registered: May 2002
|
Junior Member |
|
|
I know how to analyze sqltrace files with tkprof but when i type tkprof syntax at the dos prompt or at the sql prompt iam getting errors.
pl tell if i need to run any scripts before using tkprof.
this is very urgent kindly respond me
thanks in advance.
jeevan
|
|
|
Re: TKPROF--urgent !!!!!!!!!!!!!!!!!! [message #51572 is a reply to message #51570] |
Fri, 31 May 2002 05:29 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
hi,
what is the error?
i believe its mostly becuase of PATH setttings.
u need to execute tkprof from the OS prompt.
simplest way is to go to the trace directory,
execute the command. by default, tkprof.exe should be accessible anwhere from $ORACLE_HOME.
from the docs
Examples of TKPROF Statement
TKPROF Example 1
If you are processing a large trace file using a combination of SORT parameters and the PRINT parameter, then you can produce a TKPROF output file containing only the highest resource-intensive statements. For example, the following statement prints the 10 statements in the trace file that have generated the most physical I/O:
TKPROF ora53269.trc ora53269.prf SORT = (PRSDSK, EXEDSK, FCHDSK) PRINT = 10
TKPROF Example 2
This example runs TKPROF, accepts a trace file named dlsun12_jane_fg_sqlplus_007.trc, and writes a formatted output file named outputa.prf:
TKPROF dlsun12_jane_fg_sqlplus_007.trc OUTPUTA.PRF
EXPLAIN=scott/tiger@prod1 TABLE=scott.temp_plan_table_a INSERT=STOREA.SQL SYS=NO
SORT=(EXECPU,FCHCPU)
This example is likely to be longer than a single line on the screen, and
|
|
|
|