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