19c-19c数据库参数调整_冰山一角

http://blog.sina.com.cn/u/1294121330

首页博文目录关于我

个人资料

微博

加好友发纸条

写留言加关注

博客等级：
博客积分：

博客访问：
关注人气：
获赠金笔：0支
赠出金笔：0支
荣誉徽章：

正文字体大小：大中小

19c-19c数据库参数调整

(2019-07-30 15:35:47)

分类： Oracle DBA

SELECT a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value"

FROM x$ksppi a, x$ksppcv b, x$ksppsv c

WHERE a.indx = b.indx AND a.indx = c.indx

AND SUBSTR(ksppinm,1,1)='_'

ORDER BY a.ksppinm;

alter system set db_file_multiblock_read_count=32 scope=spfile sid='*';

alter system set max_dump_file_size = '500M' scope=spfile sid='*';

alter system set "_memory_imm_mode_without_autosga"=FALSE scope=spfile sid='*';

alter system set job_queue_processes=100 scope=spfile sid='*';

alter system set DB_FILES=4096 scope=spfile sid='*';

alter system set nls_date_format='YYYY-MM-DD HH24:MI:SS' scope=spfile sid='*';

alter system set open_cursors=3000 scope=spfile sid='*';

alter system set open_links_per_instance=48 scope=spfile sid='*';

alter system set open_links=100 scope=spfile sid='*';

alter system set parallel_max_servers=20 scope=spfile sid='*';

alter system set session_cached_cursors=200 scope=spfile sid='*';

alter system set undo_retention=10800 scope=spfile sid='*';

alter system set "_undo_autotune"=false scope=spfile sid='*';

alter system set "_partition_large_extents"=false scope=spfile sid='*';

alter system set "_use_adaptive_log_file_sync"=false scope=spfile sid='*';

alter system set "_optimizer_use_feedback"=false scope=spfile sid='*';

alter system set deferred_segment_creation=false scope=spfile sid='*';

alter system set "_external_scn_logging_threshold_seconds"=600 scope=spfile sid='*';

alter system set "_external_scn_rejection_threshold_hours"=24 scope=spfile sid='*';

alter system set result_cache_max_size=0 scope=spfile sid='*';

alter system set "_cleanup_rollback_entries"=2000 scope=spfile sid='*';

alter system set parallel_force_local=true scope=spfile sid='*'; --rac

alter system set "_gc_policy_time"=0 scope=spfile sid='*';

alter system set "_clusterwide_global_transactions"=false scope=spfile sid='*';

alter system set "_library_cache_advice"=false scope=both sid='*';

alter system set db_cache_advice=off scope=both sid='*';

alter system set filesystemio_options=setall scope=spfile sid='*';

alter system set fast_start_mttr_target=300 scope=spfile sid='*';

alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

alter profile ORA_STIG_PROFILE limit PASSWORD_LIFE_TIME UNLIMITED;

begin

DBMS_AUTO_TASK_ADMIN.DISABLE(

client_name => 'sql tuning advisor',

operation => NULL,

window_name => NULL);

end;

begin

DBMS_AUTO_TASK_ADMIN.DISABLE(

client_name => 'auto space advisor',

operation => NULL,

window_name => NULL);

end;

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report

前一篇：11g-11g数据库参数调整

后一篇：OracleDatabase-WorkingondatabaseswithSGAof1TBand2.6TB

新浪BLOG意见反馈留言板　欢迎批评指正