Re: exadata flash cache and flash disk metrics

From: Ls Cheng <exriscer_at_gmail.com>
Date: Thu, 24 Jan 2019 21:09:58 +0100
Message-ID: <CAJ2-Qb-mVnTs-pX239Lv9M9GNEcrrky3Uk5AX97Dqjo6gO2xWA_at_mail.gmail.com>



Hi

No, we dont create flash disk on top of flash cards, this is the output

CellCLI> list griddisk

         PROD_DATA1_CD_00_oracelprod01   active
         PROD_DATA1_CD_01_oracelprod01   active
         PROD_DATA1_CD_02_oracelprod01   active
         PROD_DATA1_CD_03_oracelprod01   active
         PROD_DATA1_CD_04_oracelprod01   active
         PROD_DATA1_CD_05_oracelprod01   active
         PROD_DBFS1_CD_02_oracelprod01   active
         PROD_DBFS1_CD_03_oracelprod01   active
         PROD_DBFS1_CD_04_oracelprod01   active
         PROD_DBFS1_CD_05_oracelprod01   active
         PROD_FRA1_CD_00_oracelprod01    active
         PROD_FRA1_CD_01_oracelprod01    active
         PROD_FRA1_CD_02_oracelprod01    active
         PROD_FRA1_CD_03_oracelprod01    active
         PROD_FRA1_CD_04_oracelprod01    active
         PROD_FRA1_CD_05_oracelprod01    active

Thanks

On Thu, Jan 24, 2019 at 6:23 PM Andy Wattenhofer <watt0012_at_umn.edu> wrote:

> It's possible to create flash disks on the flash cards (FDOMs) in the
> cells (see doc id 2066305.1
> <https://support.oracle.com/epmos/faces/DocContentDisplay?id=2066305.1>).
> Maybe you have those. Output of "cellcli -e list griddisk" on any cell
> would show you.
>
> Andy
>
> On Thu, Jan 24, 2019 at 10:26 AM Ls Cheng <exriscer_at_gmail.com> wrote:
>
>> Hi all
>>
>> Does anyone know the differece between these two metrics in Exadata Cells?
>>
>>
>> 1. DB_FC_IO_RQ_SM_SEC => The number of small I/O requests issued by a
>> database to flash cache per second.
>> 2. DB_FD_IO_RQ_SM_SEC => The number of small I/O requests issued by a
>> database to flash disks per second.
>>
>>
>> The difference between flash disk and flash cache precisely.
>>
>> Our is 1/8 X6 Rack with HC disks with Flash Cache however when I run LIST
>> METRICCURRENT DB_FD_IO_RQ_SM_SEC I actually see some values which is quite
>> confusing because we are using flash cache and not flash disk (instead we
>> have HC disks).
>>
>> Any lights?
>>
>> Thanks
>>
>>
>>
>>
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free.
>> www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
>> <#m_-2508171020005444544_m_2858263226018258336_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 24 2019 - 21:09:58 CET

Original text of this message