Database Tuning (MOSC)

MOSC Banner

DB CPU and SQL Execute elapsed time in Time Model Statistics in AWR report

edited Jul 6, 2016 10:13AM in Database Tuning (MOSC) 1 commentAnswered

Hello Experts,

This is the Time Model Statistics section of AWR report:

Statistic NameTime (s)% of DB Time
sql execute elapsed time686,804.6297.89
DB CPU14,579.902.08
parse time elapsed8,554.541.22
hard parse elapsed time6,611.620.94
PL/SQL execution elapsed time3,941.890.56
hard parse (sharing criteria) elapsed time2,406.100.34
connection management call elapsed time324.650.05
PL/SQL compilation elapsed time34.660.00
hard parse (bind mismatch) elapsed time25.440.00
repeated bind elapsed time21.930.00
sequence load elapsed time1.490.00
failed parse elapsed time0.510.00
DB time701,577.24
background elapsed time5,921.55
background cpu time117.49

I have a doubt.

It shows that 2.08% of DB time is spent consuming CPU and 97.89% of DB time is spent in executing SQL statements.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center