oracle 获取不到快照,【诊断方法】AWR 快照（snapshot）无法获取

【诊断方法】AWR 快照(snapshot)无法获取

TeacherWhat Oracle数据库技术

Keyword：

AWR snapshot Generation MMON Suspension

AWR是ORACLE数据库重要的诊断工具，但是有时可能遇到AWR快照无法获取的问题，影响性能监测。本文介绍如何诊断和解决这类问题。

■收集诊断信息

1.获取AWR Snapshot的设定信息和过去取得信息

set mark html on

spool Info.html

alter session set NLS_DATE_FORMAT = 'YYYY/MM/DD HH24:MI:SS';

alter session set nls_timestamp_format='YYYY-MM-DD HH24:MI:SS.FF3'

---数据库状态

select open_mode from v$database;

---AWR相关环境设定信息

show parameter control_management_pack_access

show parameter statistics

---AWR设定信息

select * from dba_hist_wr_control;

---快照的取得信息

select * from dba_hist_snapshot order by snap_id;

---快照的最新取得时间信息

col systimestamp form a35

col most_recent_snap_time form a25

col snap_interval form a17

select systimestamp,

most_recent_snap_time,

snap_interval

from wrm$_wr_control

where dbid = (select dbid from v$database);

---快照的错误信息

col instance_number form 999 head INST

col begin_interval_time form a25

col flush_elapsed form a17

col status form 999

col error_count form 999 head ERR

col snap_flag form 999 head SNAP

select * from

(select snap_id,instance_number,STARTUP_TIME，begin_interval_time,

flush_elapsed,status,error_count,snap_flag

from wrm$_snapshot

where dbid = (select dbid from v$database)

order by snap