Re: "Elapsed time" from statspack/sql_trace_tkprof_file different;
- From: "Zhu,Chao" <zhuchao@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Wed, 22 Aug 2007 07:37:29 +0800
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@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
