|
_task(task_name => 'MYADDM');
END;
/
-- Display the report.
SET LONG 100000
SET PAGESIZE 50000
SELECT DBMS_ADVISOR.get_task_report('MYADDM') AS report
FROM dual;
2. Enterprise Manager
这个就不多做说明了。
3. 相关视图
DBA_HIST_SNAPSHOT --存放的是快照信息
DBA_ADVISOR_TASKS --存放的是addm任务 Basic information about existing tasks.
DBA_ADVISOR_LOG --addm执行日志
DBA_ADVISOR_FINDINGS ---addm诊断结果概述 不同模块存放
DBA_ADVISOR_RECOMMENDATIONS ---addm诊断结果建议 不同模块存放
-The End-
----例子
create table t_test_subtemplate
(
rec_type varchar2(10),
capture_time varchar2(30),
uuid varchar2(30)
)
partition by range(capture_time)
subpartition by list(uuid)
subpartition template
(
subpartition sp00 values('1'),
subpartition sp01 values('2')
)
(
partition part_201101 values less than(20130130),
partition part_201102 values less than(20130230)
);
alter table t_test_subtemplate add partition part_201104 values less than(20130330);
|