Re: help with reading tkprof output

On Nov 15, 12:06 pm, bugbear <bugbear_at_trim_papermule.co.uk_trim> wrote:
> Under Oracle 10g (10.2.0.3.0)
>
> I have a tkprof log.
>
> The plan appears perfectly sensible,
> and the fetch runs very rapidly.
>
> The time for the "fetch" phase is nicely documented
> against the plan, with time in us for each part
> of the evaluation.
>
> But all this detail applies to the "fetch".
>
> Sadly, most of the user and elapsed time is going
> in "Excute":
>
> call count cpu elapsed disk query current rows
> ------- ------ -------- ---------- ---------- ---------- ---------- ----------
> Parse 1 0.01 0.00 0 0 0 0
> Execute 1 12.91 12.61 0 0 0 0
> Fetch 3 0.05 0.04 0 1634 0 26
> ------- ------ -------- ---------- ---------- ---------- ---------- ----------
> total 5 12.97 12.67 0 1634 0 26
>
> for which I have no "finer grained" information.
>
> So; two questions;
>
> what activities does tkprof group under "Execute" and how can I get
> finer grained information on them?
>
> Thanks to all for any help provided.
>
> BugBear

Hi,

What does the raw sql trace (10046 level 8 ) says. Also the execution plan in the tkprof.

Yo need to look at the SQL Execution plan, ie know about the buffer gets and physical reads

Thanks

www.ramsora.blogspot.com Received on Thu Nov 15 2007 - 07:28:28 CST