Meanings of 'DB Time' in AWR report summary and 'DB Time' in the instance activity stats
I would be grateful if anyone could explain the connection (if any) between the value shown under 'DB Time' in the summary section and the value shown under 'DB Time' in the 'Instance Activity Stats' section in the same, typical, 11.2.0.3 AWR report:
Extract from report summary:
|
Snap Id |
Snap Time |
Sessions |
Cursors/Session |
|
|
Begin Snap: |
476 |
19-Jun-12 16:00:21 |
905 |
79.6 |
|
End Snap: |
477 |
19-Jun-12 16:15:23 |
907 |
78.4 |
|
Elapsed: |
|
15.04 (mins) |
|
|
|
DB Time: |
|
315.40 (mins) |
|
|
Extract from instance activity stats section:
<!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39"