Some questions on AWR
edited May 18, 2011 6:30PM in Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) 4 commentsAnswered
Hi
We have a 10.2.0.4 production database on HP Open VMS 8.3 and we are trying to address some performance issues and in connection with that
need some guidance in interpreting AWR report
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 29278 18-Apr-11 13:00:14 242 9.0
End Snap: 29279 18-Apr-11 14:00:36 255 10.0
Elapsed: 60.37 (mins)
DB Time: 72.75 (mins)
Q # 1
A) In above, what does the "DB Time" reprents ?
In our case it is GREATER (72 mins) then the Elapsed time (60 mins)
If the DB Time is LESS then (lets say half of ELAPSED time) what does that mean?
Load Profile
Per Second Per Transaction
Redo size: 14,320.02 14,294.14
Logical reads: 3,007.21 3,001.78
Block changes: 38.53 38.46
We have a 10.2.0.4 production database on HP Open VMS 8.3 and we are trying to address some performance issues and in connection with that
need some guidance in interpreting AWR report
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 29278 18-Apr-11 13:00:14 242 9.0
End Snap: 29279 18-Apr-11 14:00:36 255 10.0
Elapsed: 60.37 (mins)
DB Time: 72.75 (mins)
Q # 1
A) In above, what does the "DB Time" reprents ?
In our case it is GREATER (72 mins) then the Elapsed time (60 mins)
If the DB Time is LESS then (lets say half of ELAPSED time) what does that mean?
Load Profile
Per Second Per Transaction
Redo size: 14,320.02 14,294.14
Logical reads: 3,007.21 3,001.78
Block changes: 38.53 38.46
0