3 Database Initialization Parameters
Oracle FLEXCUBE standard database initialization parameters have been
derived after performing the required benchmark tests (Performance Load tests). We
recommend installing FLEXCUBE 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 FLEXCUBE-Disk-Layouts-initparams-19c.xlsx excel sheet base lined along with this document.Following are the Parameters with the details and its relevance to FLEXCUBE:
- 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