Viewing Current Memory Utilization

Previous
Previous
Next
Next

To view current memory utilization:

  1. On the Database Home Page, click the Administration icon.

  2. Click Memory.

  3. If prompted, enter the appropriate administrator username and password and click Login.

    The Memory page appears and displays the following:

    • Maximum System Global Area (SGA). Displays Maximum SGA memory in MB. This size sets the SGA_MAX_SIZE database parameter. See "About System Global Area Memory".

    • Program Global Area (PGA). Displays PGA memory in MB. See "About Program Global Area Memory".

    • Current Configuration (SGA + PGA). Displays the sum of SGA and PGA memory in MB.

  4. To configure SGA or PGA, click Configure SGA or Configure PGA on the Tasks list on the right side of the page.