Quote Originally Posted by gandolf989 View Post
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
seem

seems u haven't got it exactly. i want to find the blocking SQL, not the SQL to find the blocked sessions.