Mandatory configuration
Most of the default Oracle settings can be used for the Oracle Central Designer database. However, the following Oracle configuration must be used.
Page | Option | Value |
---|---|---|
Database Components |
Oracle Text, a standard database component. |
Selected. Tip: The Oracle database software installation requires that you install Oracle Data Mining if you install Oracle Text. If you do not want to install Oracle Data Mining, you can install Oracle Text manually after completing the Oracle database installation. |
-- |
Oracle Java Virtual Machine (JVM) |
Selected. |
Character Sets |
Database Character Set |
AL32UTF8 - Unicode 4.0 UTF universal character set, UTF-8 compliant. |
-- |
National Character Set |
AL16UTF16 - Unicode UTF-16 universal character set. |
Parameters |
CURSOR_SHARING parameter |
FORCE |
-- |
OPEN_CURSORS parameter |
500 |
Additional configuration information
In production databases at Oracle, the DB_BLOCK_SIZE Oracle parameter is set to 16k (16384 bytes).