#
ifile=?/dbs/initbscst.ora
#
# For XB data transfer, index build and 
# validation purposes OLAP configuration of 
# BSCS Target
#
# archive log list
#   Database log mode            No Archive Mode
#   Automatic archival           Disabled
# purge dba_recyclebin
#
# Memory (SGA)
#
*.db_cache_size=26G               
*.shared_pool_size=5G
*.log_buffer=78643200
*.large_pool_size=5G 
*.java_pool_size=250M
*.streams_pool_size=250M
*.sga_max_size=40G
*.sga_target=0
#
# Memory (PGA)
#
*.pga_aggregate_target=100G
*.workarea_size_policy='AUTO'
*._pga_max_size=3650000000     # Maximum size of the PGA memory for one process
*._smm_max_size=425000         # Maximum work area size in auto mode (serial)
*._smm_px_max_size=68000000    # Maximum work area size in auto mode (global)
*.hash_area_size=157286400
*.sort_area_size=157286400
*.sort_area_retained_size=157286400
#
# CPU
#
*.parallel_threads_per_cpu=4
*.parallel_adaptive_multi_user=FALSE
*.parallel_min_servers=360
*.parallel_max_servers=520
*.processes=1000
*.sessions=1005
#
# Disk
#
*.disk_asynch_io=true
*.filesystemio_options=setall
*.db_writer_processes=12             
*.db_file_multiblock_read_count=128  
#
# Misc
#
*.compatible=10.2.0
*.optimizer_features_enable=10.2.0.3
*.optimizer_mode=ALL_ROWS 
*.optimizer_dynamic_sampling=4
*.cursor_sharing=EXACT
*.db_block_checksum=FALSE
*.db_block_checking=FALSE 
*.db_cache_advice=OFF
*.job_queue_processes=0
*.aq_tm_processes=0
*.recyclebin=off
*.statistics_level=BASIC
*.timed_statistics=TRUE
*.parallel_execution_message_size=8192
*.fast_start_mttr_target=3600 
*.log_checkpoint_interval=0 
*.log_checkpoint_timeout=0 
*.undo_retention=36000 
*.resumable_timeout=3600 
*.session_cached_cursors=2000
*._system_trig_enabled=false