2 Database Initialization Parameters
Oracle standard database initialization parameters have been derived after performing the required benchmark tests (Performance Load tests). We recommend installing Oracle Banking Trade Finance in Pluggable database and few of these parameters need to be set at PDB level.
Note:
Since some of the initialization parameters values are specific to customer volume, parameters should be derived using Oracle Banking Trade Finance -Disk-Layouts-initparams-19c.xlsx excel sheet baselined along with this document.- ALLOW_LEVEL_WITHOUT_CONNECT_BY
- LM_RES_HASH_BUCKET
- CURSOR_SHARING
- DB_CACHE_ADVICE
- FAST_START_MTTR_TARGET
- JOB_QUEUE_PROCESSES
- LOG_BUFFER
- MEMORY TARGET/MEMORY_MAX_TARGET
- NLS_DATE_FORMAT
- OPEN_CURSORS
- OPTIMIZER_DYNAMIC_SAMPLING
- OPTIMIZER_INDEX_CACHING
- OPTIMIZER_INDEX_COST_ADJ
- PARALLEL_MAX_SERVERS
- PGA_AGGREGATE_LIMIT
- PLSQL_CODE_TYPE
- PROCESSES
- REMOTE_DEPENDENCIES_MODE
- SESSION_CACHED_CURSORS
- SKIP_UNUSABLE_INDEXES
- UNDO_RETENTION