Re: divide with decode

Srinivas:

What you're looking to do is find the value of physical reads/db block gets. So, you want the value1/value2 where value1 is 'physical reads' and value2 is 'db block gets'. So, what you need to do is put the literals 'physical reads' and 'db block gets' in the where clause somehow rather than use decode. There are several ways to do this, but here is the way I would:

select physical_reads/db_block_gets as
from (select to_number(value) as physical_select physical_reads/db_block_gets as reads_per_get   from (select to_number(value) as physical_reads

          from sys.v_$sysstat
         where name = 'physical reads')
     , (select to_number(value) as db_block_gets
          from sys.v_$sysstat
         where name = 'db block gets');

Jon Walthour
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, August 04, 2001 12:20 PM

> hi lists
>
> can anybody help me for the flwng :
>
> i need to do calculation dividing phy reads value/db block gets
>
> i am following the principle
>
> select decode(name,'physical reads',value)/decode(name,'db block
> gets',value)
> from v$sysstat
> where name in ('db block gets','physical reads')
>
> just this query is returning notthing.
>
> i tried with to_number function also, that is not also returning
> anything.
>
> is there any trick to solve this.
>
> srinivas
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tatireddy, Shrinivas (MED, Keane)
> INET: Shrinivas.Tatireddy_at_med.ge.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Walthour
  INET: jonw_at_fuse.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).