Database Tuning (MOSC)

MOSC Banner

H ow to analyze Time Model Statistic

edited Sep 27, 2016 5:00AM in Database Tuning (MOSC) 2 commentsAnswered

Hello Experts,

This is the Time Model Statistics section of AWR report: H ow to analyze below Time Model Statistic

Statistic Name

Time (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

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