Configuring or Reconfiguring the Database

The settings described in this section are intended to serve as starting values only. Monitor the database and analyze performance data to fine-tune the settings for your system environment. Tuning an Oracle database involves an Oracle SYS DBA.

The recommendations provided in this section are based on the assumption that PPM is the only application that uses the database instance. If other applications share the database, adjust the recommended parameter values accordingly.

Note: If Oracle Database is running over Oracle VM (OVM), we recommend you enable the Hard Partitioning feature, also known as CPU pinning.

For more information, see Oracle VM documentation:

Note: For more recommendations on improving PPM performance, see the Deployment Best Practices for PPM Operational Reporting.