DB time from awr

I was recently looking to understand an AWR report after reading about learning AWRs.

Here is a sample output from a prod DB:

[image: Inline image 1]

I am looking at the TMS (time model stats) section and I have 2 qns about it:

[image: Inline image 2]

1. Why is total % well above 100.
2. 'sql execute elapsed time' is only 44%! what was the system doing rest of the time. Is it right to assume that 44% of sql exec elapsed time is bad?

Same server, 1 hour before:

[image: Inline image 3]

And I was looking at the AWR for the same DB from a week later for a period of 3 hours, the total % of DB time only add up to 82%, 83% and 86% respectively during three consecutive hours. That was the time when things were 'real bad' for the users.

Can someone help me understand this? v11.2

CP

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image.png



image/png attachment: image.png



image/png attachment: image.png