- 博客(5)
- 收藏
- 关注
转载 Oracle ADDM 自动诊断监视工具 介绍
一. ADDM概述 ADDM(Automatic Database Diagnostic Monitor) 是植入Oracle数据库的一个自诊断引擎.ADDM 通过检查和分析AWR获取的数据来判断Oracle数据库中可能的问题. 在Oracle9i及之前,DBA们已经拥有了很多很好用的性能分析工具,比如,tkprof、sql_trace、statspack、set even
2014-08-14 13:45:52 634
原创 How to use STA(sql tuning advisor)
一、手工生成Sql tuning advisor 1、SQL text format:DECLARE my_task_name VARCHAR2(30); my_sqltext CLOB;BEGIN my_sqltext := 'SELECT * FROM DBA_SEGMENTS WHERE OWNER=''CLIC'' AND SEGMENT_TYPE=''T
2014-08-12 18:08:31 884
原创 How to use segment advisor
1、查看segment advisor方法一:select * fromtable(dbms_space.asa_recommendations('TRUE','FALSE','FALSE')); dbms_space.asa_recommentdations的三个参数:all_runs TURE返回历次运行的结果,FALSE则返回最近一次运行的结果show_ma
2014-08-12 16:45:04 1156
原创 ORA-31693, ORA-02354 and ORA-01555 with Export Datapump
SymptomsORA-31693: Table data object "YXFUND"."MF_NOTTEXTANNOUNCEMENT" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing dataORA-01555: snapshot t
2014-08-12 12:32:43 3269
原创 PX Deq: Execution Msg,PX Deq: Execute Reply等待事件
PX Deq: Execution MsgOccurs when a parallel slave is waiting to be told what to do. This is normally considered an idle event, but can cause excessive CPU in some cases.SolutionReduc
2014-08-11 17:48:20 3733
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人