select count(*) from gv$session where lockwait is not null;

hostgator