Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help with reading tkprof output

Re: help with reading tkprof output

From: sybrandb <sybrandb_at_gmail.com>
Date: Thu, 15 Nov 2007 05:45:56 -0800 (PST)
Message-ID: <46af8837-ea22-4170-a270-76fd2883f7d3@b36g2000hsa.googlegroups.com>


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
Received on Thu Nov 15 2007 - 07:45:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US