*._bloom_filter_enabled=FALSE
*._cursor_reload_failure_threshold=4
*._fix_control='12914055:OFF'
*._kttext_warning=1
*._optimizer_dsdir_usage_control=0
*._serial_direct_read='NEVER'
*._sql_plan_directive_mgmt_control=0
*._sys_logon_delay=0
*._use_adaptive_log_file_sync='FALSE'
*._use_single_log_writer='TRUE'
*.aq_tm_processes=1
*.archive_lag_target=900
*.audit_file_dest='/paic/gbs/gbs/data/app/oracle/admin/gbs/adump'
*.audit_sys_operations=FALSE
*.audit_trail='DB'
*.cell_offload_processing=FALSE
*.compatible='12.1.0.2.0'
*.control_files='/paic/gbs/gbs/data/oradata/gbs/control01.ctl','/paic/gbs/gbs/data/oradata/gbs/control02.ctl','/paic/gbs/gbs/data/oradata/gbs/control03.ctl','/paic/gbs/gbs_fra/oradata/gbs/controlfile/control04.ctl'
*.core_dump_dest='/paic/gbs/gbs/data/app/oracle/admin/gbs/cdump'
*.db_block_size=8192
*.db_cache_size=128849018880
*.db_domain='world'
*.db_files=8000
*.db_flashback_retention_target=10080
*.db_keep_cache_size=104857600
*.db_name='gbs'
*.db_recovery_file_dest='/paic/gbs/gbs_fra/oradata/gbs'
*.db_recovery_file_dest_size=7516192768000
*.db_unique_name='gbs'
*.db_writer_processes=8
*.deferred_segment_creation=FALSE
*.enable_goldengate_replication=TRUE
*.fal_client='GBS'
*.fal_server='LGBS'
*.fast_start_mttr_target=900
*.fast_start_parallel_rollback='FALSE'
*.filesystemio_options='SETALL'
*.java_pool_size=293601280
*.job_queue_processes=100
*.large_pool_size=2097152000
*.local_listener='GBSLOCAL'
*.log_archive_config='DG_CONFIG=(gbs,lgbs,rgbs,lgbs_tmp)'
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'
*.log_archive_dest_2=''
*.log_archive_dest_3='SERVICE=lgbs lgwr async noaffirm reopen=60 valid_for=(online_logfiles,primary_role) db_unique_name=lgbs'
*.log_archive_dest_4='SERVICE=lgbs_tmp lgwr async noaffirm reopen=60 valid_for=(online_logfiles,primary_role) db_unique_name=lgbs_tmp'
*.log_archive_dest_state_2='DEFER'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_dest_state_4='ENABLE'
*.log_archive_format='gbs_%r_%t_%s.arc'
*.log_archive_max_processes=10
*.log_buffer=33554432
*.log_checkpoints_to_alert=true
*.max_dump_file_size='100000000'
*.O7_DICTIONARY_ACCESSIBILITY=false
*.open_cursors=1200
*.open_links=200
*.open_links_per_instance=200
*.optimizer_adaptive_plans=FALSE
*.optimizer_capture_sql_plan_baselines=FALSE
*.optimizer_features_enable='12.1.0.2'
*.optimizer_secure_view_merging=FALSE
*.optimizer_use_sql_plan_baselines=TRUE
*.parallel_degree_limit='4'
*.parallel_execution_message_size=32768
*.parallel_max_servers=60
*.parallel_min_servers=0
*.pga_aggregate_limit=0
*.pga_aggregate_target=48103424000
*.processes=7500
*.recyclebin='OFF'
*.resource_limit=TRUE
*.resource_manager_plan=''
*.service_names='gbs'
*.session_cached_cursors=300
*.shared_pool_size=17179869184
*.standby_file_management='AUTO'
gbs.streams_pool_size=436207616
*.temp_undo_enabled=FALSE
*.undo_management='AUTO'
*.undo_retention=86400
*.undo_tablespace='UNDOTBS1'
db_cache_size=235520m
shared_pool_size=35328m
pga_aggregate_target=55050m
MAXLOGFILES 80
MAXLOGMEMBERS 3
MAXDATAFILES 12800
MAXINSTANCES 8
MAXLOGHISTORY 18688
---19c参数
alter system set "_optimizer_adaptive_cursor_sharing"=false scope=spfile;
alter system set "_optimizer_extended_cursor_sharing_rel"='NONE' scope=spfile;
alter system set "_optimizer_extended_cursor_sharing"='NONE' scope=spfile;
alter system set "_serial_direct_read"='NEVER' scope=spfile;
alter system set "_undo_autotune"=false scope=spfile;
alter system set "_use_adaptive_log_file_sync"='FALSE' scope=spfile;
--rac
alter system set "_gc_policy_time"=0 scope=spfile;
alter system set "_gc_undo_affinity"=false scope=spfile;
alter system set "_asm_hbeatiowait"=120 scope=spfile;
--sharepoint 参数
alter system set "_serial_direct_read"='NEVER' scope=spfile;
alter system set "_use_adaptive_log_file_sync"=FALSE scope=spfile;
alter system set "_use_single_log_writer"=TRUE scope=spfile;
alter system set "_kttext_warning"=1 scope=spfile;
alter system set "_sys_logon_delay"=0 scope=spfile;
alter system set "_cursor_obsolete_threshold"=1024 scope=spfile;
alter system set "_optimizer_use_feedback"=FALSE scope=spfile;
alter system set "_optimizer_gather_feedback"=FALSE scope=spfile;
alter system set "_cursor_reload_failure_threshold"=4 scope=spfile;
alter system set "_shared_io_pool_size"=512m scope=spfile;
--专有参数
alter system set "_shared_pool_reserved_pct"=15 scope=spfile;
alter system reset shared_pool_reserved_size;
---
alter system set db_domain='world' scope=spfile;
alter system set "_optimizer_dsdir_usage_control"='OFF' scope=spfile;
alter system set "_rollback_segment_count"=200 scope=spfile;
alter system set db_files=20000 scope=spfile;
alter system set fast_start_parallel_rollback='LOW' scope=spfile;
alter system set job_queue_processes=200 scope=spfile;
alter system set open_cursors=1200 scope=spfile;
alter system set open_links=200 scope=spfile;
alter system set open_links_per_instance=200 scope=spfile;
alter system set log_archive_max_processes=15 scope=spfile;
alter system set log_buffer=134176768 scope=spfile;
alter system set max_dump_file_size=52428800 scope=spfile;
alter system set parallel_max_servers=80 scope=spfile;
alter system set recyclebin='OFF' scope=spfile;
alter system set session_cached_cursors=300 scope=spfile;
alter system set standby_file_management='AUTO' scope=spfile;
alter system set streams_pool_size=536870912 scope=spfile;
alter system set temp_undo_enabled=TRUE scope=spfile;
alter system set undo_management='AUTO' scope=spfile;
alter system set undo_retention=86400 scope=spfile;
alter system set optimizer_adaptive_plans=FALSE;
