Re: exadata flash cache and flash disk metrics

ops no, just saw in the documentation the temporary read/write is only spilled to flash only when WBFC is enabled which is not our case.....

On Thu, Jan 24, 2019 at 9:12 PM Ls Cheng <exriscer_at_gmail.com> wrote:

> Hi
>
> We are using flashCacheMode WriteThrough not WBFC. It must be Temp Writes
> then. Let me see if I can drilled down further, will have a look the script
>
> Thanks!
>
>
> On Thu, Jan 24, 2019 at 6:54 PM Karl Arao <karlarao_at_gmail.com> wrote:
>
>> is your WBFC enabled ? starting cell version 12.2.1.1.0, if WBFC is
>> enabled temp writes also goes to FD
>>
>>
>> https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/whats-new-oracle-exadata-database-machine-12c-release-2-12.2.1.1.0.html#GUID-FFFDCB63-308F-4B08-A917-D635686920E6
>>
>> check this (
>> https://github.com/karlarao/cellmetricstoolkit/blob/master/1_gen_scl.sh)
>> as a reference on how you can breakdown the IO further, start from CG up to
>> the CD.
>>
>> CG - consumer group
>> DB - database
>> FC and FL - flash
>> CD - cell disk
>>
>> Then correlate that with your perf hub Exadata Section. Then you'll be
>> able to see patterns and and numbers to chase and workload periods
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Thu, Jan 24, 2019 at 11:31 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_-1757146818410109124_m_393670549255745374_m_-5391896866109542471_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>
>>
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l