List Users Waiting on Resources

-- seswait.sql

select username,

is_wlatch, -- blocked waiting on a latch

is_wlock, -- blocked waiting on a locked record or table

is_wbuff, -- blocked waiting on a buffer

is_wckpt, -- blocked waiting on a checkpoint

is_incrit -- session is in a critical section of transaction

-- (e.g writting to disk)

from syssessions

order by username;

Sample Output

username is_wlatch is_wlock is_wbuff is_wckpt is_incrit

lester 0 1 0 0 0

lester 0 0 0 0 0

lester 0 0 0 0 0

Previous slide

Next slide

Back to first slide

View graphic version