PGA is a memory region that contains data and control information for a server process. For more information, see the
Memory Architecture section of the
Oracle Database Administration Guide.
Note: The preceding link was correct as of January 1, 2015. If you find the link is broken, provide feedback and a VMware employee will update the link. From the performance reports on an Oracle database, if you see that the biggest wait times are for the read and writes to the temporary data file, then this indicates that the PGA size is set too low and must be resized to a larger value.
Note: This is an issue during a reboot of vCenter Server, but not during normal running process.
For example, this is an Oracle performance report with high read and write wait times:
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~
Event Waits Time(s) Avg wait(ms) % DB Time
----------------------------------------- ------------ ----------- ------------------ -----------
direct path read temp 1,876,465 14,476 8 62.4
direct path write temp 219,404 5,844 27 25.2
CPU time 1,111 4.8
control file sequential read 5,356 364 68 1.6
control file parallel write 276 355 1286 1.5
------------------------------------------------------------------------------------------------------
For the preceding report, PGA must be resized.