Enabling Manual Shared Memory Management

Follow these steps to enable manual shared memory management:

  1. In Oracle Enterprise Manager Database Express (EM Express), from the Configuration menu, select Initialization Parameters.

    The Initialization Parameters page appears.

  2. In the Search field, enter SGA_TARGET.
  3. Select SGA_TARGET, and then click Set.

    The Set Initialization Parameter page appears.

  4. In the Value field, enter 0, specify a Scope of Memory, and then click OK.

    A confirmation message appears.

    Note:

    This step sets SGA_TARGET to 0 for the current session. To set SGA_TARGET to 0 and keep it in effect after the database is restarted:

    • If your database uses a server parameter file, specify a Scope of SPFile as well as a Scope of Memory on the Set Initialization Parameter page.

    • If your database uses a text initialization parameter file, manually set the value of SGA_TARGET to 0 in that file.

  5. In the Search field, enter MEMORY_TARGET.
  6. Select MEMORY_TARGET, and then click Set.

    The Set Initialization Parameter page appears.

  7. In the Value field, enter 0, specify a Scope of Memory, and then click OK.

    A confirmation message appears.

    Note:

    This step sets MEMORY_TARGET to 0 for the current session. To set MEMORY_TARGET to 0 and keep it in effect after the database is restarted:

    • If your database uses a server parameter file, specify a Scope of SPFile as well as a Scope of Memory on the Set Initialization Parameter page.

    • If your database uses a text initialization parameter file, manually set the value of MEMORY_TARGET to 0 in that file.

  8. From the Configuration menu, select Memory.

    Note that under the SGA Memory section, the Management Mode value is now Manual. This indicates that manual shared memory management is enabled.

    Description of the illustration man_mem_mgmt_crop.gif follows
    Description of the illustration man_mem_mgmt_crop.gif
  9. For details on setting values for the various SGA components, see Oracle Database Administrator's Guide.