Re: ASM parameters

From: Bob Jones <email_at_me.not>
Date: Sat, 26 Jan 2008 14:21:53 -0600
Message-ID: <wDMmj.5547$Rg1.4485@nlpi068.nbdc.sbc.com>

"Steve Howard" <stevedhoward_at_gmail.com> wrote in message news:0b2436f4-d9d6-4e7c-b3e4-a8c3540ddd9e_at_e4g2000hsg.googlegroups.com...
> On Jan 26, 2:12 pm, "Bob Jones" <em..._at_me.not> wrote:

>> "Mladen Gogala" <mgog..._at_yahoo.com> wrote in message
>> > I wonder whether buffer cache hit ratio would make sense for the ASM
>> > instances and how to calculate it. I will let you know of my findings.
>> > --
>> >http://mgogala.freehostia.com
>>
>> (db block gets + consistent gets - physical reads)/(db block gets +
>> consistent gets)
>>
>

> Sorry, no can do...
>

> SQL> select instance_name,startup_time from gv$instance;
>

> INSTANCE_NAME STARTUP_TIME
> ---------------- -------------------
> +ASM1 2008_01_24 20:02:58
> +ASM2 2008_01_25 11:42:44
>

> SQL> select inst_id,name,value
> 2 from gv$sysstat
> 3* where name in('db block gets','consistent gets','physical
> reads');
>

> INST_ID NAME VALUE
> ---------- ------------------------------ ----------
> 1 db block gets 0
> 1 consistent gets 0
> 1 physical reads 0
> 2 db block gets 0
> 2 consistent gets 0
> 2 physical reads 0
>

> 6 rows selected.

>
> SQL>
These stats may not be applicable for ASM then. Received on Sat Jan 26 2008 - 14:21:53 CST

Original text of this message