dba_waiters show not all waiting session: do you know wether this is intentional so not a bug?
Hello,
Oracle 11.1.0.3PSU5
we monitor waiting session by reading dba_waiters, but today it's happens, that the monitor say, there is no waiting session even if there exists one!! With V$session and asking for blocking_session we could find the waiting session. Could it be, that dba_waiters show only session which wait on event "enq: TX - row lock contention"? The event of the waiting session which not shown by dba_waiter is "log file sync".
Here the query of the monitor with dba_waiters:
SELECT
holding_session bsession_id,
waiting_session wsession_id,
b.username busername,
a.username wusername,
Oracle 11.1.0.3PSU5
we monitor waiting session by reading dba_waiters, but today it's happens, that the monitor say, there is no waiting session even if there exists one!! With V$session and asking for blocking_session we could find the waiting session. Could it be, that dba_waiters show only session which wait on event "enq: TX - row lock contention"? The event of the waiting session which not shown by dba_waiter is "log file sync".
Here the query of the monitor with dba_waiters:
SELECT
holding_session bsession_id,
waiting_session wsession_id,
b.username busername,
a.username wusername,
0