Previous Topic

Next Topic

Book Contents

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.

Send Feedback