Oracle database configuration

This topic provides information about configuring and monitoring Oracle database.

Table 1. Mandatory init parameters
Parameter	Mandatory value
cursor_sharing	Exact
Character set	AL32UTF8

Table 2. Recommended init parameters
Parameter	Recommended value
db_block_size	8192
processes	1040 [basic setting, needs to be monitored and updated accordingly ]
open_cursors	300 [basic setting, needs to be monitored and updated accordingly]
nls_length_semantics	BYTE
sessions	2088 [basic setting, needs to be monitored and updated accordingly ]

Basic Database privileges required for the db user (master schema user and test mode schema user):

grant "CONNECT" to <USER>;
grant CREATE TABLE to <USER>;

Note: PEM only supports configurations using the default schema associated with the respective database users.