List,
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