Foglight 5.9.7 - Performance Tuning Field Guide

Oracle Tuning

When tuning an Oracle® backend database, you should first read the information below. You want the information you obtain to be sufficient enough for you to make decisions about the initial setup and configuration of the Oracle backend. Once the backend is operational, a DBA should use Oracle tools to check the parameters of execution and adjust them based on the observed behavior.

How the Management Server Uses the Database

The following are the Foglight® Management Server backend database usage characteristics:

The following sections elaborate on specific aspects of Oracle® parameters.

Index Management

We recommend you consult Oracle® analysis tools to check the effectiveness of indices used by the Foglight® Management Server. There are no known backend operations through the Management Server that would invalidate specific indices on particular events. Indices should only be rebuilt at the discretion of the DBA, after a thorough analysis of the behavior of the backend at runtime has been performed.

Memory

At the moment, there is no direct correlation between the amount of memory required by the Foglight® Management Server and the amount of memory required for the database. The management tools that ship with Oracle® can provide some tuning information to help you understand how much memory the database requires at load time.

Typically, we would expect that for a Management Server heap of 1 GB, the database System Global Area (SGA) should be between 1 and 2 GB. This should be set up at the DBA’s discretion.