DB init.ora for Flexcube

init.ora parameter recommendation for Flexcube:

FCUAT12.__data_transfer_cache_size=0

FCUAT12.__db_cache_size=9797894144

FCUAT12.__java_pool_size=67108864

FCUAT12.__large_pool_size=268435456

FCUAT12.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

FCUAT12.__pga_aggregate_target=4160749568

FCUAT12.__sga_target=12482248704

FCUAT12.__shared_io_pool_size=536870912

FCUAT12.__shared_pool_size=1677721600

FCUAT12.__streams_pool_size=0

*._allow_level_without_connect_by=TRUE

*.audit_file_dest='/u01/app/oracle/admin/FCUAT12/adump'

*.audit_trail='db'

*.compatible='12.1.0.2.0'

*.control_files='/data/oratest/FCUAT12/control01.ctl','/data/fast_recovery_area/FCUAT12/control02.ctl'

*.cursor_sharing='FORCE'

*.db_block_size=8192

*.db_cache_advice='OFF'

*.db_domain=''

*.db_name='FCUAT12'

*.db_recovery_file_dest='/data/fast_recovery_area'

*.db_recovery_file_dest_size=4560m

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=FCUAT12XDB)'

*.fast_start_mttr_target=300

*.job_queue_processes=16

*.log_buffer=115343360

*.memory_max_target=16642998272

*.memory_target=16642998272

*.nls_date_format='DD-MON-RRRR'

*.open_cursors=5000

*.optimizer_dynamic_sampling=1

*.optimizer_index_caching=90

*.optimizer_index_cost_adj=90

*.parallel_adaptive_multi_user=FALSE

*.parallel_max_servers=32

*.pga_aggregate_limit=0

*.pga_aggregate_target=3960m

*.plsql_code_type='NATIVE'

*.plsql_optimize_level=2

*.processes=550

*.remote_dependencies_mode='SIGNATURE'

*.remote_login_passwordfile='EXCLUSIVE'

*.session_cached_cursors=400

*.sga_target=11881m

*.skip_unusable_indexes=FALSE

*.undo_retention=1800

*.undo_tablespace='UNDOTBS1'

*.utl_file_dir='*'