Quote Originally Posted by mahajanakhil198 View Post
Is there any other way to find the SQL because of which other sessions are blocked?
SYS@outreach AS SYSDBA> select * from dba_blockers;

no rows selected

Elapsed: 00:00:00.09
SYS@outreach AS SYSDBA> select * from dba_Waiters;

no rows selected

Elapsed: 00:00:00.01