Mandatory database parameters
Most of the default Oracle configuration parameters can be used for the Central Coding database. However, the following parameters must be set to the specified values.
Descriptions of mandatory database parameters
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: 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.