Recommendations for Oracle Configurations

Allocate a minimum of 1 GB of memory for the database instance.
Configure Oracle initialization parameters:
- log_buffer
- open_cursors
- cursor_sharing
Separate redo logs from other database files.
Create separate tablespaces for Data Seg, Data Map Seg, and work tables.
Configure the work table tablespace with no logging.
As a minimum, use a tablespace size of 1 GB. The tablespace size requirement is dependant on the amount of data and the size of the applications.
Set the Configuration Settings for the Oracle tablespaces as described in Oracle Initialization Parameters.
Set the work table bitmap index switch to Off for Oracle 10g and Oracle 11g.

Note:

Because indexing may result in a significant performance decrease, FDM data tables are not indexed.