| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
