1. Installation and Configuration Guide
  2. Preparing Your Environment
  3. Preparing a Database
  4. Using an Oracle Database
  5. Oracle Database Tablespace Considerations

Oracle Database 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 Oracle Enterprise Performance Management 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.

Oracle Hyperion Financial Reporting

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

Oracle Hyperion Financial Management

Set up a temporary tablespace greater than 1GB.
Oracle Hyperion Financial Close Management

See the Oracle Hyperion Financial Close Management Performance Tuning Guide, which can be found on Oracle Support by searching for document ID 1575381.1

Oracle 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