session time model issue
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Jan 2013 12:49:44 +0100
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@xxxxxxxxxx>
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
