How to Reduce the SGA in "Oracle Database"

The Oracle system global area controls the shared memory resources for large Oracle database farms. You change the SGA settings using the "alter system" command available in Oracle Enterprise Manager software. You must have administrative rights to reduce the SGA allocated memory space. Reduce the allocation when you have too much memory allocated and you do not use it across the network.

Instructions

1. Open the Oracle Enterprise Manager software on a desktop that has access to the Oracle database server.

2. Log in to the server using your administrator username and password. Open the PL/SQL editor.

3. Type the alter statement to reduce the SGA memory allocation. The following code reduces the SGA to 5 gigabytes:

   alter system SHARED_POOL_SIZE = 5 G

4. Click "Run" to execute the command. A success message returns when the update finishes.

References

• Oracle: SHARED_POOL_SIZE