常用运维脚本
Chad2017
这个作者很懒,什么都没留下…
展开
-
HANG分析与SYSTEMDUMP分析
Collection commands for Hanganalyze and Systemstate: Non-RAC:Sometimes, database may actually just be very slow and not actually hanging. It is therefore recommended, where possible to get 2 hangan转载 2017-07-14 14:43:21 · 631 阅读 · 0 评论 -
日常维护SQL以及脚本
----调整DG的传输进程为ARCHics: alter system set log_archive_dest_3 ='SERVICE=lics arch async noaffirm reopen=60 valid_for=(online_logfiles,primary_role) db_unique_name=lics' scope =both;原创 2017-07-06 14:12:29 · 1167 阅读 · 0 评论 -
library cache lock和library cache pin
1.找到holder的addr:select sid,event,p1,P1RAW,p1text,p2,p3 fromv$session_wait where wait_time=0 and event like 'library cache%'; 2.确认hold住的对象:selectaddr,kglhdadr,kglhdpar,kglnaown,kglnaobj,kglnahs原创 2017-07-06 18:48:51 · 86 阅读 · 0 评论 -
OUTLINE转换为SPM
----根据CATAGORY转化declare migrate_out clob;beginmigrate_out := dbms_spm.migrate_stored_outline(attribute_name => 'CATEGORY',attribute_value => 'SPECIAL',fixed => 'YES');end;----根据OUTLINE原创 2017-07-06 19:12:08 · 290 阅读 · 0 评论 -
SQL获取AWR信息
----快照排序select snap_id,dbid,end_time from (select snap_id,dbid,to_char(end_interval_time,'yyyy-mm-dd hh24:mi:ss') end_time from dba_hist_snapshotorder by end_interval_time desc)where rownum原创 2017-07-06 19:14:04 · 980 阅读 · 0 评论