Re: Database Hit Ratios

In article <B950FF27.3902E%markbtownsend_at_attbi.com>, Mark says...
>
>
>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
>

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

      0

:)

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Tue Jul 09 2002 - 23:44:15 CDT