<< Click to Display Table of Contents >>

SGA Statistics

Top Previous Next

The page gives an overview of the size of the SGA and its components. It is divided into three parts.

The upper left box shows the

Fixed Size

Variable Size

Database Buffers Size

Redo Buffers Size

The upper right box displays the following information about  the SGA components:

Pool

SGA Component Name

Memory Size (Kbytes)

Size as a percentage of the entire SGA

A grid at the bottom of the page displays the values of some of the initialization parameters that are relevant to the SGA. It also shows whether a parameter can be dynamically altered through an ALTER SYSTEM or ALTER SESSION command, and whether the current value is equal to the value in the init.ora file