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" <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
