Skip to Main Content
  • Questions
  • sql execute elapsed time in awr report

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Anju.

Asked: February 04, 2017 - 5:20 am UTC

Last updated: February 06, 2017 - 2:46 pm UTC

Version: 11.2.0.1

Viewed 10K+ times! This question is

You Asked

Hello Experts

Does "sql execute elapsed time" in AWR report include parse time as well?

I am getting time model statistics for a session as :

SQL> set pagesize 200
set line 500
select stat_name, value/1000000 seconds from v$sess_time_model
where sid=36
order by value desc, stat_name ;

STAT_NAME SECONDS
---------------------------------------------------------------- ----------
DB time 46.920067
sql execute elapsed time 46.804663
DB CPU 44.241273
parse time elapsed 42.98521
hard parse elapsed time 38.000074
PL/SQL execution elapsed time 1.518585
PL/SQL compilation elapsed time .253508
failed parse elapsed time .073542
connection management call elapsed time .020886
repeated bind elapsed time .002607
hard parse (sharing criteria) elapsed time .001194
Java execution elapsed time 0
RMAN cpu time (backup/restore) 0
background cpu time 0
background elapsed time 0
failed parse (out of shared memory) elapsed time 0
hard parse (bind mismatch) elapsed time 0
inbound PL/SQL rpc elapsed time 0
sequence load elapsed time 0

19 rows selected.


Thanks and regards
Anju Garg

and Connor said...

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Elements common to parse time elapsed” and “sql execute elapsed time"

Anju Garg, February 06, 2017 - 5:46 am UTC

Hello Connor

The link you provided is indeed very useful. However, I have a question:
OU training material says:

Even though “parse time elapsed” is not considered a child of “sql execute elapsed time,” there are some elements that are considered in both.

I would like to know about the elements which are considered in both “parse time elapsed” and “sql execute elapsed time” .

Thanks in advance
Anju Garg
Connor McDonald
February 06, 2017 - 2:46 pm UTC

Is that training material online ? If so, can you post the link - and I'll see if I can get the OU people to have a look as to what they meant.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.