Re: Database Hit Ratios

select count(*) waiting
from v$session_wait sw, v$session s
where s.osuser = 'mtownsen'

  and sw.event = 'obligatory sheep joke'
  and sw.wait_time = 0
  and sw.sid = s.sid

WAITING

      1 Received on Tue Jul 09 2002 - 22:59:20 CDT