查看统计数据.txt

来自「在oracle中」· 文本 代码 · 共 51 行

--查看统计了什么东西
select * from v$statistics_level;

--查看workload_repository的基本设置;
select * from dba_hist_wr_control;

--修改workload_repository的基本设置;
exec dbms_workload_repository.modify_snapshot_settings(
  retention=>21600,
  interval =>30
);

--创建快照
exec sys.dbms_workload_repository.create_snapshot();

--查看快照历史
select * from dba_hist_snapshop;

--删除快照历史
exec dbms_workload_repository.drop_snapshot_range(4650,4720);

--查看会话历史
select * from v$active_session_history;

--查看AWR报告
$ORACLE_HOME/rdbms/admin/awrrpt.sql
或
$ORACLE_HOME/rdbms/admin/awrrpti.sql


--ADDM部分
--生成ADDM报告
$ORACLE_HOME/rdbms/admin/addmrpt.sql

--查看ADDM在２４小时内生成的报告
select type,count(*) 
  from  dba_advisor_findings
   natural join dba_advisor_tasks
  where created between sysdate-1 and sysdate
  group by type

--查看某一推荐
select message 
  from  dba_advisor_recommendations
   nature join dba_advisor_findings
    using(finding_id,task_id)
  where rank=0

--更改addm设置
 exec dbms_advisor.set_default_task_parameter(
  'ADDM','DBIO_EXPECTED',16000);