Configuring System Global Area Memory

Previous

Next

---

The System Global Area (SGA) is a memory area that contains data shared between all database users such as buffer cache and a shared pool of SQL statements. SGA is allocated in memory when an Oracle Database XE instance is started, and any change in the value will take effect at the next startup.

The amount of memory allocated to SGA directly affects the performance of your database. The SGA sizes are configured automatically when you install Oracle Database XE.

To alter SGA memory:

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. See "Viewing Current Memory Utilization".

4. From the Task list, select Configure SGA.

5. In SGA Target, enter a new value in MB.

6. Click Apply Changes.

For SGA size changes, you must shut down and restart the database for the changes to take effect.