Enable or Disable Database In-Memory

You can enable or disable Database In-Memory from the Details page of an Autonomous Database.

Please see Database In-Memory for the requirements and guidelines to use this feature with Autonomous Database.

Required IAM Permissions

use autonomous-databases

Procedure

  1. Go to the Details page of the database for which you want to enable or disable Database In-Memory. For instructions, see View Details of a Dedicated Autonomous Database

    Note:

    For databases that use Autonomous Data Guard, go to the Details page of the primary database.

  2. Click Edit under Resource Allocation. The page to manage resources is opened.
  3. To enable Database In-Memory, select Enable database In-memory. If this check box is pre-selected, deselecting it will disable Database In-Memory.

    Note:

    You can also open the page to enable or disable database in-memory in another way. On Oracle Public Cloud, Under More actions, click Manage resource allocation. On Exadata Cloud@Customer, click Manage scaling.
  4. When you enable Database In-Memory, adjust the slider to set a percentage of System Global Area (SGA) to the In-Memory area.
  5. Submit the details and apply your changes.