这篇文章主要介绍了数据库中如何查看故障时间等待事件、问题sql及会话访问次数，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。

DBA_HIST_ACTIVE_SESS_HISTORY

DBA_HIST_ACTIVE_SESS_HISTORY displays the history of the contents of the in-memory active session history of recent system activity. This view contains snapshots of V$ACTIVE_SESSION_HISTORY. See "V$ACTIVE_SESSION_HISTORY" for further interpretation details for many of these columns (except SNAP_ID, DBID, and INSTANCE_NUMBER).

查看故障时间段等待事件、问题sql id及会话访问次数

--altersessionsetnls_date_format='yyyy-mm-ddhh34:mi:ss';selecttrunc(sample_time,'mi')tm,sql_id,nvl(event,'CPU'),count(distinctsession_id)cntfromdba_hist_active_sess_historywheresample_timebetweento_date('2019-08-2214:00:00')andto_date('2019-08-2214:30:00')groupbytrunc(sample_time,'mi'),sql_id,nvl(event,'CPU')orderbycntdesc;

查看该sql相关的等待事件及对应的会话访问次数

selectsql_id,nvl(event,'CPU'),count(distinctsession_id)szfromdba_hist_active_sess_historya,dba_hist_snapshotbwheresample_timebetweento_date('2019-08-2214:00:00')andto_date('2019-08-2215:00:00')andsql_id='4ksvn2rgjnhcm'anda.snap_id=b.snap_idanda.instance_number=b.instance_numbergroupbysql_id,nvl(event,'CPU')orderbyszdesc;

感谢你能够认真阅读完这篇文章，希望小编分享的“数据库中如何查看故障时间等待事件、问题sql及会话访问次数”这篇文章对大家有帮助，同时也希望大家多多支持亿速云，关注亿速云行业资讯频道，更多相关知识等着你来学习!