Database Settings

This section outlines database configuration settings and JDBC parameter tuning, with detailed guides available for Shared Services, HFM, and Essbase.

Create an Oracle 12c database with AL32UTF8 character set encoding, and set the following database parameters:

• ALTER SYSTEM SET processes=2000 SCOPE=SPFILE;
  ALTER SYSTEM SET OPEN_CURSORS=5000 SCOPE=SPFILE;
  ALTER SYSTEM SET SESSION_CACHED_CURSORS=200 SCOPE=SPFILE;
  ALTER SYSTEM SET SESSIONS=2000 SCOPE=SPFILE;

• The sqlnet.ora file in the database server (in %ORACLE_HOME%\product\xx.x.x\dbhome_1\network\admin\sqlnet.ora) should have the following setting: sqlnet.expire_time=10

• Set the max_string_size setting to standard.

After setting parameters, restart Oracle Database (both the Listener and the Oracle Database service).

Optionally, you can specify unlimited quota for EPM schemas.