Description of the illustration mem_param

This screenshot shows the PGA subpage of the Memory Parameters page. It contains the following fields, arranged vertically at the left-hand side of the page: Aggregate PGA Target (with a current value of 188 MB), Current PGA Allocated (with a current read-only value of 99285 KB), Maximum PGA Allocated (since startup) (with a current read-only value of 136450 KB), and Cache Hit Percentage (with a current value of 100%). To the right of the Aggregate PGA Target field is an Advice button.

Below these fields is a PGA Memory Usage Details button. Below this button is a tip that reads as follows: The sum of PGA and SGA should be less than the total system memory minus memory required by the operating system and other applications.