Enabling Oracle Database In-Memory for the Audit Vault Server

After you enable Oracle Database In-Memory, you can monitor it.

About Enabling Oracle Database In-Memory for Oracle Audit Vault Server

You can enable Oracle Database In-Memory for Oracle Audit Vault Server.

You can improve the performance of Oracle Database Security Central reports and dashboards by enabling Oracle Database In-Memory in Oracle Audit Vault Server. This feature lets you allocate a certain amount of system memory for audit data for a specified period of time. The audit data residing in-memory then becomes available more quickly for use in dashboards and reports.

Based on the amount of system memory you allocate for Oracle Database In-Memory, and the average amount of data collected per day in your environment, Oracle Database Security Central calculates the number of days of audit data that will fit into that allocated memory. From this calculation, the system displays the in-memory date range toOracle Database Security Central auditors, letting them know the time ranges for which they can obtain faster reports. For example, if 1 gigabyte can accommodate 2 days of data, and you have provided 1 gigabyte of memory for Oracle Database In-Memory, then 2 days of the latest data will be put in Oracle Database In-Memory. If you provide 2 gigabytes of memory to Oracle Database In-Memory, then 4 days of data will go to Oracle Database In-Memory.

Before enabling Oracle Database In-Memory, be sure to estimate the amount of memory needed for your current and future targets and Database Firewall monitoring points. You can find some guidelines for calculating RAM requirements in the Oracle Database Security Central Sizing Advice (My Oracle Support Doc ID 2092683.1). This document can be obtained from Oracle Support. After estimating your normal RAM requirements, if you want to use the Oracle Database In-Memory feature, estimate how much RAM you want to use for in-memory database and add that to your RAM requirement. If you enable this feature, you must allocate at least 1 GB for Oracle Database In-Memory.

Enabling and Allocating Memory for Oracle Database In-Memory

You can enable and allocate memory for Oracle Database In-Memory from the Oracle Database Security Central console.

  1. Log in to the Oracle Database Security Central console as a super administrator.

  2. Select Settings.

  3. In the left navigation menu, select select System.

  4. Under Configuration, select Oracle Database In-Memory.

  5. In the Oracle Database In-Memory dialog, select the Enable Oracle Database In-Memory checkbox.

    The Oracle Database In-Memory window expands to show the total system RAM.

  6. If you have sufficient memory on your system, configure the following settings:

    • Allocated In-Memory field: Enter (or change) the amount of RAM to allocate in Gigabytes. You must enter a minimum of 1 (default), and up to Maximum available for Database In-Memory indicated on this dialog.

    • Keep latest data option: Select this option to retain the data that has just been collected. This setting enables the system to automatically select the most recent dates, based on the in-memory size that was configured.

    • Select a date range option: Select this option if you want the memory to be available for a specific period of time.

  7. Select Save.

    After you enable or disable Oracle Database In-Memory, the Audit Vault Server database, Audit Vault Agents, and audit trails shut down for a few minutes, and then restart automatically.

Disabling Oracle Database In-Memory

You can disable Oracle Database In-Memory from the Oracle Database Security Central console.

  1. Log in to the Oracle Database Security Central console as a super administrator.

  2. Select Settings.

  3. In the left navigation menu, select System.

  4. Under Configuration section, select Oracle Database In-Memory.

  5. In the Oracle Database In-Memory window, select the Enable Oracle Database In-Memory checkbox to clear it. If enabled, the disable option is available in the dialog.

  6. Select Save.

    After you enable or disable Oracle Database In-Memory, the Audit Vault Server database, Audit Vault Agents, and audit trails go down for a few minutes, and then restart automatically.

Monitoring Oracle Database In-Memory Usage

You can monitor the Oracle Database In-Memory usage from the Oracle Database Security Central console.

To see in-memory usage in the Audit Vault Server dashboard:

  1. Select Settings.

  2. In the left navigation menu, select select System.

  3. Under Configuration, select Oracle Database In-Memory.

  4. The Oracle Database In-Memory dialog contains all the details.