1. Standard Deployment Guide
  2. Setting Up Oracle Database
  3. Database Settings

Database Settings

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.