Mandatory database parameters

Most of the default Oracle configuration parameters can be used for the Oracle Central Coding database. However, the following parameters must be set to the specified values.

Parameter	Value
Database Character Set	AL32UTF8 - Unicode UTF-8 Universal character set
National Character Set	AL16UTF16 - Unicode UTF-16 Universal character set
db_cache_size	80 MB
sga_max_size	1000 MB
sga_target	600 MB (dependent on how much memory is available for Oracle)
pga_aggregate_target	300 MB (dependent on how much memory is available for Oracle)
BLOCK_SIZE	Database: 8k or 16k Tablespace: 16k

Note:

Your database administrator should dynamically adjust the sga_target and pga_aggregate_target values using Oracle Enterprise Manager Advisors as the system grows.

Note:

Oracle recommends that the Oracle instance registry parameter ORA_*SID*_AUTOSTART be set to True. This ensures that Oracle is synchronized with the job scheduler, which is an auto-started service.