Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Hit Ratios

Re: Database Hit Ratios

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 10 Jul 2002 08:48:27 +0100
Message-ID: <1026287387.13426.2.nnrp-10.9e984b29@news.demon.co.uk>

Clearly you guys have very little experience with Oracle in the real world.
<British humour - hyperbole variant>

Never assume that wait_time = 0 is
synonymous with state='WAITING'.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

Pete Sharman wrote in message ...

>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 Wed Jul 10 2002 - 02:48:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US