Oracle Enterprise Manager (SYSTEM)

Database Instance: ablinux > Memory Parameters

You are not logged on with SYSDBA privilege. Only controls for dynamic parameters are editable

Memory Parameters

Page Refreshed

2009. szeptember 14. 15:31:34 CEST

SGA

PGA

The System Global Area (SGA) is a group of shared memory structures that contains data and control information for one Oracle database. The SGA is allocated in memory when an Oracle database instance is started.

Allocation History

This chart shows the history of the components of the SGA.

Current Allocation

Automatic Shared Memory Management

Enabled

Total SGA Size (MB)

SGA Component	Current Allocation (MB)
Shared Pool	224
Buffer Cache	880
Large Pool	16
Java Pool	32
Other	16

Maximum SGA Size

The Maximum SGA Size specifies the maximum memory that the database may allocate. If you specify the Maximum SGA Size, you can later dynamically change the Total SGA Size above (provided Total SGA Size does not exceed the Maximum SGA Size).

Maximum SGA Size* (MB)

SGA

PGA

Apply changes to SPFILE only

The changes are made to both the SPFILE and the running instance which requires that you restart the database to invoke static parameters.