oracle 升级12c参数样例

alter system set audit_trail=DB scope=spfile;

alter system set shared_pool_size=2000M scope=spfile;

alter system set shared_pool_reserved_size=160M scope=spfile;

alter system set large_pool_size=176M scope=spfile;

alter system set db_cache_size=5000M scope=spfile;

alter system set streams_pool_size=128M scope=spfile;

alter system set java_pool_size=80M scope=spfile;

Alter system set DB_SECUREFILE='ALWAYS' scope=both;

Alter system set parallel_execution_message_size=32768 scope=spfile;

ALTER SYSTEM SET RESOURCE_LIMIT = TRUE;

alter system set deferred_segment_creation=false scope=both;

alter system set sec_case_sensitive_logon = false scope=both;

alter system set db_writer_processes = 4 scope=spfile;

alter system set archive_lag_target=900 scope=both;

alter system set fast_start_parallel_rollback=false scope=both;

alter system set fast_start_mttr_target=300 scope=both;

alter system set undo_retention=10800 scope=both ;

alter system set cell_offload_processing=false scope=both;

alter system set db_securefile='ALWAYS' scope=both ;

alter system set filesystemio_options='SETALL' scope=spfile;

alter system set log_checkpoints_to_alert=true scope=both;

alter database set default smallfile tablespace;

alter system set optimizer_secure_view_merging=false scope=spfile;

alter system set "_serial_direct_read"=never scope=both ;

alter system set "_use_adaptive_log_file_sync"=false scope=both ;

alter system set "_kttext_warning"=1 scope=both ;

alter system set event ="28401 TRACE NAME CONTEXT FOREVER, LEVEL 1" scope=spfile;

alter profile default limit failed_login_attempts unlimited;

alter profile default limit password_grace_time unlimited;

alter profile default limit password_lock_time unlimited;

alter profile default limit password_life_time unlimited;

noaudit alter system;

noaudit create external job;

noaudit create session;

noaudit role;

noaudit profile;

noaudit grant any role;

noaudit system grant;

noaudit create any procedure;

noaudit alter any procedure;

noaudit drop any procedure;

noaudit alter profile;

noaudit drop profile;

noaudit grant any privilege;

noaudit create any library;

noaudit exempt access policy;

noaudit grant any object privilege;

noaudit create any job;

noaudit system audit;

noaudit directory;

exec dbms_stats.set_global_prefs(pname=>'METHOD_OPT', pvalue=>'FOR ALL COLUMNS SIZE 1');

exec dbms_stats.set_global_prefs(pname=>'PUBLISH', pvalue=>'TRUE');

exec dbms_stats.alter_stats_history_retention(365);

exec dbms_workload_repository.modify_snapshot_settings(retention=>129600,interval=>15);

exec dbms_spm.configure('space_budget_percent',30);

exec dbms_auto_task_admin.disable(client_name=>'auto space advisor',operation=>NULL,window_name=>NULL);

exec dbms_auto_task_admin.disable(client_name=>'sql tuning advisor',operation=>NULL,window_name=>NULL);

exec dbms_stats.gather_dictionary_stats;

alter system set aq_tm_processes = 1 scope = both;

exec dbms_stats.gather_fixed_objects_stats;

alter system set aq_tm_processes = 0 scope = both;

alter system reset aq_tm_processes scope = spfile;

alter database add supplemental log data;

alter database force logging;

alter system set optimizer_capture_sql_plan_baselines = false scope = both;

ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = '' SCOPE=BOTH;

execute dbms_scheduler.set_attribute('WEEKNIGHT_WINDOW','RESOURCE_PLAN','');

execute dbms_scheduler.set_attribute('WEEKEND_WINDOW','RESOURCE_PLAN','');

exec DBMS_STATS.SET_TABLE_PREFS ('SYS', 'WRI$_OPTSTAT_SYNOPSIS$','INCREMENTAL', 'FALSE');