session time model issue

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 8 Jan 2013 12:49:44 +0100
Message-ID: <50EC07D8.20704_at_nordea.com>

hi,

in the Oracle documentation there is stated that parse time elapsed and sql execute elapsed time are counted on the same level ie. they are accounted into DB time (exec time + parse time + other stuff = DB time)

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.

I know that for example using OCI the traditional calls to parse, execute and fetch cover much more complex reality and the real amounts of parsing, executing or fetching is not really the time one could measure between the calls, so question is how to interpret those values.

The db version is 11.2.0.2

excerpt from tkprof report indicates almost no parsing and almost all is execute
call count cpu elapsed disk query current

    rows
------- ------ -------- ---------- ---------- ---------- ----------

---

Parse        1      0.00       0.00          0          0          0
       0
Execute      1      8.86      16.78         27      13336          0
       0
Fetch        1      0.09       0.32         20       7278          0
       1

------- ------ -------- ---------- ---------- ---------- ----------

---

total        3      8.95      17.11         47      20614          0
       1

Best regards
Remigiusz

-- 
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 Tue Jan 08 2013 - 12:49:44 CET