Oracle Database Privileges and Parameters

• Grant privileges to database users:

  • CREATE ANY SYNONYM

  • CREATE CLUSTER

  • CREATE INDEXTYPE

  • CREATE PROCEDURE

  • CREATE SEQUENCE

  • CREATE SESSION

  • CREATE TABLE

  • CREATE TRIGGER

  • CREATE TYPE

  • CREATE VIEW

  • DROP ANY SYNONYM

• Set 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.

For Oracle Database, for performance reasons, the database block size should be no larger than 8k.

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

Tip:

Optionally, you can specify unlimited quota for EPM schemas.

EPM System database accounts must be created in a tablespace with a minimum initial capacity of 1 GB.