Re: V$active session history
- From: Vishal Gupta <vishal@xxxxxxxxxxxxxxx>
- To: "rjanuary@xxxxxxxxx" <rjanuary@xxxxxxxxx>
- Date: Fri, 20 Mar 2015 09:25:38 +0000
Ryan,
Session does have to be active for 10 secs to be included in AWR sample. AWR
takes top 10% of the rows for every second and stored in repository.
Regards,
Vishal Gupta
On 19 Mar 2015, at 18:11, Ryan January <rjanuary@xxxxxxxxx> wrote:
I agree with Jeremy, but have a slight correction. As I understand it, every
10th ASH sample will make it to the dba_hist* views. A sql statement wouldn't
have to be active a full 10 seconds to be included. That session can sit idle
for 9.999 seconds and, by being active at just the right time, be included in
the AWR sample.
> On Mar 19, 2015, at 1:05 PM, Jeremy Schneider
> <jeremy.schneider@xxxxxxxxxxxxxx> wrote:
>
> every SQL that runs for more than 1 second will show up in
> v$active_session_history (until the memory buffer cycles around).
> every SQL that runs for more than 10 seconds will be retained in the
> dba_hist_* view.
Other related posts:
