Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What sessions are considered Active by ASH?

April 26, 2017active ash sessions

0

Posted

What sessions are considered Active by ASH?

1 Answer

0

Posted

Any session (both foreground and background sessions) that is connected to the database instance and is waiting for a wait event that does not belong to the Idle wait class is considered an active session. Database sessions that were on the CPU at the time of sampling are also considered active. The column SESSION_STATE in V$ACTIVE_SESSION_HISTORY should help identify whether a session was sampled because it was ‘WAITING’ for some non-idle wait event or it was ‘ON CPU’ at the time of sampling.