DBA Hub

📋Steps in this guide1/1

Find blocking sessions

SELECT s.inst_id, s.blocking_session, s.sid, s.serial#, s.seconds_in_wait FROM gv$session s WHERE blocking_session IS NOT NULL;

oracle configurationintermediate
by OracleDba
14 views
1

Find blocking sessions

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
SELECT
s.inst_id,
s.blocking_session,
s.sid,
s.serial#,
s.seconds_in_wait
FROM
gv$session s
WHERE
blocking_session IS NOT NULL;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!