Re: "Elapsed time" from statspack/sql_trace_tkprof_file different;

I am comparing per Execution cost/elapsed time. Total elapsed time / total executions = per execution cost. they are comparable.

On 8/22/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> Assuming your stats below are for the same query, your tkprof is only
> accounting for 32945 executions while the statspack is accounting for
> almost 1 million executions so you're not comparing apples to apples.
>
> Regards,
> Brandon
>

-- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l