Re: High elapsed/cpu ratio

On 10.09.2007, ebwright_at_gmail.com <ebwright_at_gmail.com> wrote:
>
> The tkprof file has the following at the end in the summary section
>
> Elapsed times include waiting on following events:
> Event waited on Times Max. Wait Total
> Waited
> ---------------------------------------- Waited ----------
> ------------
> SQL*Net message to client 21
> 0.00 0.00
> SQL*Net message from client 21
> 0.00 0.00
>

Was this session traced with wait events information? alter session set events '10046 trace name context forever, level 12'

> Is there something else in the raw trace file for which I should be
> looking?
>

Lines starting with "WAIT". But those should be summarized in tkprof report (in they are present).

-- 
Wiktor Moskwa