SAP系统oracle初始化参数
*._B_TREE_BITMAP_PLANS=FALSE
*._IN_MEMORY_UNDO=FALSE
*._INDEX_JOIN_ENABLED=FALSE
*._OPTIM_PEEK_USER_BINDS=FALSE
*._OPTIMIZER_MJC_ENABLED=FALSE
*._SORT_ELIMINATION_COST_RATIO=10
*._TABLE_LOOKUP_PREFETCH_SIZE=0
*.background_dump_dest='/oracle/PRD/saptrace/background'
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf','/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf','/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'
*.core_dump_dest='/oracle/PRD/saptrace/background'
*.db_block_size=8192
*.db_cache_size=8407398481
PRD.db_cache_size=7566524416
*.db_files=254
*.db_name='PRD'
*.dml_locks=4000
*.event='10191 trace name context forever, level 1'
*.filesystemio_options='setall'
*.job_queue_processes=1
*.log_archive_dest='/oracle/PRD/oraarch/PRDarch'
*.log_buffer=1048576
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.open_cursors=800
*.parallel_execution_message_size=16384
*.pga_aggregate_target=11209864642
*.processes=300
*.query_rewrite_enabled='false'
*.recyclebin='off'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.sessions=300
*.sga_max_size=16814796963
*.shared_pool_reserved_size=840739848
*.shared_pool_size=8407398481
*.sort_area_retained_size=0
*.sort_area_size=2097152
*.star_transformation_enabled='true'
PRD.streams_pool_size=855638016
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='/oracle/PRD/saptrace/usertrace'
*._B_TREE_BITMAP_PLANS=FALSE
*._IN_MEMORY_UNDO=FALSE
*._INDEX_JOIN_ENABLED=FALSE
*._OPTIM_PEEK_USER_BINDS=FALSE
*._OPTIMIZER_MJC_ENABLED=FALSE
*._SORT_ELIMINATION_COST_RATIO=10
*._TABLE_LOOKUP_PREFETCH_SIZE=0
*.control_file_record_keep_time=30
*.control_files='/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf','/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf','/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'
*.core_dump_dest='/oracle/PRD/saptrace/background'
*.db_files=254
*.dml_locks=4000
*.event='10191 trace name context forever, level 1'
*.filesystemio_options='setall'
*.job_queue_processes=1
*.log_archive_dest='/oracle/PRD/oraarch/PRDarch'
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.open_cursors=800
*.parallel_execution_message_size=16384
*.pga_aggregate_target=11209864642
*.processes=300
*.query_rewrite_enabled='false'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.star_transformation_enabled='true'
*.undo_retention=43200
*.user_dump_dest='/oracle/PRD/saptrace/usertrace'
*._B_TREE_BITMAP_PLANS=FALSE
*._IN_MEMORY_UNDO=FALSE
*._INDEX_JOIN_ENABLED=FALSE
*._OPTIM_PEEK_USER_BINDS=FALSE
*._OPTIMIZER_MJC_ENABLED=FALSE
*._SORT_ELIMINATION_COST_RATIO=10
*._TABLE_LOOKUP_PREFETCH_SIZE=0
*.background_dump_dest='/oracle/PRD/saptrace/background'
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf','/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf','/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'
*.core_dump_dest='/oracle/PRD/saptrace/background'
*.db_block_size=8192
*.db_cache_size=8407398481
PRD.db_cache_size=7566524416
*.db_files=254
*.db_name='PRD'
*.dml_locks=4000
*.event='10191 trace name context forever, level 1'
*.filesystemio_options='setall'
*.job_queue_processes=1
*.log_archive_dest='/oracle/PRD/oraarch/PRDarch'
*.log_buffer=1048576
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.open_cursors=800
*.parallel_execution_message_size=16384
*.pga_aggregate_target=11209864642
*.processes=300
*.query_rewrite_enabled='false'
*.recyclebin='off'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.sessions=300
*.sga_max_size=16814796963
*.shared_pool_reserved_size=840739848
*.shared_pool_size=8407398481
*.sort_area_retained_size=0
*.sort_area_size=2097152
*.star_transformation_enabled='true'
PRD.streams_pool_size=855638016
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='/oracle/PRD/saptrace/usertrace'
*._B_TREE_BITMAP_PLANS=FALSE
*._IN_MEMORY_UNDO=FALSE
*._INDEX_JOIN_ENABLED=FALSE
*._OPTIM_PEEK_USER_BINDS=FALSE
*._OPTIMIZER_MJC_ENABLED=FALSE
*._SORT_ELIMINATION_COST_RATIO=10
*._TABLE_LOOKUP_PREFETCH_SIZE=0
*.control_file_record_keep_time=30
*.control_files='/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf','/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf','/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'
*.core_dump_dest='/oracle/PRD/saptrace/background'
*.db_files=254
*.dml_locks=4000
*.event='10191 trace name context forever, level 1'
*.filesystemio_options='setall'
*.job_queue_processes=1
*.log_archive_dest='/oracle/PRD/oraarch/PRDarch'
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.open_cursors=800
*.parallel_execution_message_size=16384
*.pga_aggregate_target=11209864642
*.processes=300
*.query_rewrite_enabled='false'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.star_transformation_enabled='true'
*.undo_retention=43200
*.user_dump_dest='/oracle/PRD/saptrace/usertrace'