Re: session time model issue
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 <remigiusz.sokolowski_at_nordea.com> 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
-- Jeremy Schneider Pythian Consulting Group Chicago +1 312-725-9249 http://www.pythian.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 09 2013 - 04:48:59 CET