(\AWR(从ORACLE 10G后预安装到ORACLE中)
自动工作负载资料库(automatic workload repository)
查看当前的AWR保存策略:
col SNAP_INTERVAL format a20
col RETENTION format a20
SELECT * FROM DBA_HIST_WR_CONTROL;
0.set collation time
BEGIN
DBMS_WORKLOAD_REPOSITORY.modify_snapshot_settings(
retention => 43200, -- Minutes (43200 = 30 Days).
-- Current value retained if NULL.
interval => 30); -- Minutes. Current value retained if NULL.
END;
/
1、手工创建一个快照:
EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();
2、查看AWR的快照ID
SELECT SNAP_ID,
TO_CHAR(BEGIN_INTERVAL_TIME,'yyyy-mm-dd hh24:mi:ss') BEGIN_INTERVAL_TIME,
TO_CHAR(STARTUP_TIME,'yyyy-mm-dd hh24:mi:ss') STARTUP_TIME
FROM DBA_HIST_SNAPSHOT ORDER BY 1;
3、获取AWR报告:
@?/rdbms/admin/awrrpt
4、如果用 sys 之外的用户创建 AWR