Oracle Database Configuration Considerations

Tablespace Considerations

The following table describes the Oracle Database tablespace considerations.

Product

Tablespace Considerations
General—All products

  • Consider a global view of tablespaces and allocate one or more tablespaces in order to spread out tables created by EPM System products.

  • Tablespaces can be shared with other applications.

  • Create a separate tablespace for indexes to improve performance. This action requires CREATE TABLESPACE system privileges.

  • Ensure that the SEGMENT SPACE MANAGEMENT parameter is set to AUTO when you create tablespace, to improve performance.

Reporting and Analysis

Dedicate a tablespace to Reporting and Analysis. Determine the tablespaces to be used as the default tablespace and the temporary tablespace for this user. Do not use the SYSTEM tablespace.

Financial Management

Set up a temporary tablespace greater than 1GB.

FDMSee the Oracle Hyperion Financial Data Quality Management DBA Guide.
Data Relationship Management

  • Set the initial tablespace size to 1 GB

  • Extents to 500 MB

  • Turn Auto Extend ON

See the Oracle Hyperion Data Relationship Management Installation Guide

Other Parameters

The following table describes other Oracle Database parameters.

Product

Other Parameters
General/All Products

Set the nls_length_semantics parameter to char:

nls_length_semantics=char
PlanningFor Oracle Database 10g, Planning recommends that CURSOR_SHARING in Oracle be set to the default setting, "EXACT."
Financial Management

Set Oracle OPEN_CURSORS to 5000.

Performance ScorecardSet Oracle OPEN_CURSORS to 1500 or greater.
FDMSee the Oracle Hyperion Financial Data Quality Management DBA Guide.