Oracle Session Activity


The following script shows the event that is blocking the sessions with high activity

if no rows are displayed it means that the database is working fine with no blocking sessions 

 select

   event,blocking_session,wait_class,
   count( sid)  sessions_waiting
    from
   v$session
where
   blocking_session is not NULL
   group by event,blocking_session,wait_class
order by
   count(1) desc;




2 Comments

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post