开发者社区> jan1990> 正文

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 sc...
+关注继续查看

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');

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
处理动态SQL语句的参数
原文:处理动态SQL语句的参数 经常对SQL进行开发,写动态的SQL语句,是少之不了的,但是在使用动态语句中,常是因为有动态的参数的出现。参考下面代码示例:   正因为有了标记1的动态条件代码,而让SQL语句需要变成动态的SQL语句。
674 0
php cli模式下获取参数的方法
  PHP在cli模式下接收参数有两种方法   1.使用argv数组   2.使用getopt方法   1.使用argv数组
1269 0
【RAC】asm_diskgroups 参数
初始化参数asm_diskgroups指定了在ASM实例启动时,或执行alter diskgroup all mount语句时,被挂载的磁盘组的名字,即当ASM实例启动的时候,会挂载这个参数指定的所有磁盘组,或当执行alter diskgroup all mount/dismount语句时,也会挂载这个参数指定的所有磁盘组。
659 0
oracle参数文件、控制文件、数据文件、日志文件存放位置查看
1.参数文件和网络连接文件 SQL> show parameter spfile; NAME TYPE VALUE -----------------------------------...
709 0
Oracle优化器的optimizer_mode参数
optimizer_mode参数   optimizer_mode是oracle 11g的一个优化器参数,在某些时候可以影响优化器的行为,是个不可忽视的细节参数。 SQL> show parameter optimizer; optimizer_capture_sql_plan_baselines.
2866 0
oracle 安装要用到的内存相关参数详解
在这里,对oracle在/etc/sysctl 要用到的参数值做个简要的解释和说明。 (1)kernel.shmmax:该参数定义了共享内存段的最大尺寸(以字节为单位)。
733 0
+关注
43
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
JS零基础入门教程(上册)
立即下载
性能优化方法论
立即下载
手把手学习日志服务SLS,云启实验室实战指南
立即下载