Re: session time model issue

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Thu, 10 Jan 2013 11:54:49 +0100
Message-ID: <50EE9DF9.2080701_at_nordea.com>



Point taken - almost whole parse time elapsed is counted as hard parse and in trace file there is a lot of recursive queries as this is quite a complex query.

So an additional question - how to treat these stats - because recursive sql is done on behalf of parsing actually?

On 09.01.2013 17:51, Tanel Poder wrote:
> Hi Remigiusz,
>
> This seems to happen (at least in some versions) when a (hard) parse
> causes recursive SQL execution (for data dictionary access, FGAC
> predicate generation etc) ...
>
> --
> Tanel Poder
> New Online Training! - http://blog.tanelpoder.com/seminar
> The Voicee App - http://voic.ee
>
>
> On Wed, Jan 9, 2013 at 3:09 PM, Remigiusz Sokolowski
> <remigiusz.sokolowski_at_nordea.com
> <mailto:remigiusz.sokolowski_at_nordea.com>> wrote:
>
> On 09.01.2013 04:48, Jeremy Schneider wrote:
> > On Tue, 8 Jan 2013 12:49:44 +0100
> > Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com
> <mailto: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.
>

-- 
Pole na kazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : Senior DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A st, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedziba w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisana do Rejestru Przedsiebiorców Krajowego Rejestru Sadowego pod numerem: 0000021828, 
dla której dokumentacje przechowuje Sad Rejonowy Gdansk - Pólnoc w Gdansku, 
VIII Wydzial Gospodarczy Krajowego Rejestru Sadowego, 
o kapitale zakladowym i wplaconym w wysokosci: 277.493.500,00 zlotych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 10 2013 - 11:54:49 CET

Original text of this message