Home » RDBMS Server » Performance Tuning » TKPROF HELP
TKPROF HELP [message #65104] Fri, 30 April 2004 00:23
Monu
Messages: 5
Registered: April 2004
Junior Member
I am new to tkprof and i need help on it.
i have some stored procedures and packages and i need to collect info. on them using tkprof.
i was able to do it as follows
sql>alter session set timed_statistics=true;
sql>alter session set sql_trace=true;
sql>set autotrace on;
then i ran these procedures and got the trace files,and then used the tkprof utility to get the statistics in an output file...!
Now what i want to know is that ,how do i read the tkprof output(ie interpretation of it)
there are some value in cpu,elapsed...etc

so does a low value of cpu ,elapsed is better for these procdures

So basically i want to know that the values given under cpu time,elapsed time can be used to infer that a procedure is running fine.

can you also tell me that whether hit ratio for a query be between 95-100%.

Thanks
Monu
Previous Topic: foreign keys affect performance?
Next Topic: TKPROF STATISTICS-To Mr.Daljit Singh
Goto Forum:
  


Current Time: Wed Sep 30 11:59:49 CDT 2020