Oracle的V$ACTIVE_SESSION_HISTORY视图提供实例中的会话活动采样。活动会话每秒被采样并存储在SGA的循环缓冲区中。本文讨论了ASH的刷新和清除策略，以及如何进行在线和离线分析，包括使用ashdump_loader等脚本进行数据加载和分析。
http://download.oracle.com/docs/ ... autostat.htm#i35568
-----
5.1.1.3 Active Session History (ASH)
The V$ACTIVE_SESSION_HISTORY view provides sampled session activity in the instance. Active sessions are sampled every second and are stored in a circular buffer in SGA. Any session that is connected to the database and is waiting for an event that does not belong to the Idle wait class is considered as an active session. This includes any session that was on the CPU at the time of sampling.
Each session sample is a set of rows and the V$ACTIVE_SESSION_HISTORY view returns one row for each active session per sample, returning the latest session sample rows first. Because the active session samples are stored in a circular buffer in SGA, the greater the system activity, the smaller the number of seconds of session activity that can be stored in the circular buffer. This means that the duration for which a session sampl
最低0.47元/天 解锁文章
1203
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
