Re: help with reading tkprof output

On Nov 15, 1: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

Execute usually means 'sort'.
As you don't post the execution plan, I can not confirm this.

--
Sybrand Bakker
Senior Oracle DBA