AWR report - defination of W/A MB Process
solvetekJan 28 2013 — edited Jan 28 2013Question:
------------
What is the definition of “W/A MB Process” in the AWR Report below?
Does it represent the total number of megabytes of data that was sorted by the instance between 26-Jan-13 04:00:52 and 26-Jan-13 05:00:56?
Also
What is the defination of "Extra W/A MB Read/Written"
See AWR report below
----------------------------
WORKLOAD REPOSITORY report for
DB Name DB Id Instance Inst num Startup Time Release RAC
HSTPRD 1890835983 hstprd 1 15-Dec-12 21:12 11.1.0.7.0 NO
Host Name Platform CPUs Cores Sockets Memory (GB)
njgphstprd AIX-Based Systems (64-bit) 2 1 64.00
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 15361 26-Jan-13 04:00:52 50 2.4
End Snap: 15362 26-Jan-13 05:00:56 51 2.4
Elapsed: 60.08 (mins)
DB Time: 11.50 (mins)
PGA Aggr Summary
• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
57.19 12,142 9,089
Thanks,
Edited by: solvetek on Jan 28, 2013 10:29 AM