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;
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;
Tags:
Oracle
USEFUL
ReplyDeleteuseful topic
ReplyDelete