Blocking Sessions

We can use view to identify blocking sessions. Below query checking blocking sessions > 60 seconds.

RAC / Cloud RDS:

SELECT   inst_id, blocking_session,    sid,   serial#,    seconds_in_wait FROM   gv$session WHERE    blocking_session IS NOT NULL and seconds_in_wait > 60 ;

NON-RAC / Cloud RDS:

SELECT   blocking_session,    sid,   serial#,    seconds_in_wait FROM   v$session WHERE    blocking_session IS NOT NULL and seconds_in_wait > 60 ;