Re: session time model issue

From: Jeremy Schneider <>
Date: Tue, 8 Jan 2013 21:48:59 -0600
Message-ID: <20130108214859.44214ef5_at_jeremy-nb>

On Tue, 8 Jan 2013 12:49:44 +0100
Remigiusz Sokolowski <> wrote:

> I have just reviewed the session time model gathered for a single
> query. My concern is that parse time elapsed is nearly 97% (and
> actually the whole amount is attributed to hard parse) of the DB time
> and sql execute elapsed time is 99% of the DB time.
> As this is for one session I assume there is no possibility the sum of
> ingredients is more than DB time (of course by much), so it seems
> reasonable to assume sql execute elapsed time is execute, fetch and
> parse, which is against the docs.

Hi Remigiusz,

I don't think that execute time includes parsing or fetching. Could you give a little more detail about exactly what source data and calcuations you used to find the 97% and 99% on this one particular session?


Jeremy Schneider
Pythian Consulting Group

+1 312-725-9249
Received on Wed Jan 09 2013 - 04:48:59 CET

Original text of this message