Re: Doubt about Oracle Exadata Smart Flash

Hi Eriovaldo ,

There seems to be a misunderstanding. Even if set a segment to CELL_FLASH_CACHE keep, it won't be loaded automatically. It must be read to get there, just like with buffer cache. You can set partitions and evens LOBs to CELL_FLASH_CACHE  keep; Some more information:
http://guyharrison.squarespace.com/blog/2010/7/7/the-flash-cache-keep-option.html

Regards

Lothar
Am 18.02.2018 um 13:48 schrieb Eriovaldo Andrietta:
> Hello,
>
> I am preparing to start working with Oracle Exadata (X6-2 1/8 with
> storage expansion) and I am reading about this subject and found this
> text :
>
> "Oracle Exadata Smart Flash Cache is smart because it knows when
> to avoid trying to cache data that will never be reused or will
> not fit in the cache. Oracle Database and Oracle Exadata System
> Software allow the user to provide directives at the database
> table, index and segment level to ensure that specific data is
> retained in flash. Tables can be moved in and out of flash with a
> simple command, without the need to move the table to different
> tablespaces, files or LUNs as is done with traditional storage
> using flash disks."
>
>
> My doubts :
>
> Wich are DDL commands to set directives in order to save or not
> save the object in the Flash Cash ? Where can I get it  ?
>
> Having a partitioned table,  Is is possible to save only one
> partition in the Flash Cash (the most recent , the current year /
> month) and others in the traditional storage ? Does it make sense ?
>
> Also , I am looking for material oriented to development and
> performance monitoring in this environment. Where can I get it ?
>
>
> Does anyone knows how it works ?
>
> Thanks in advance for any feedback.
>
> Eriovaldo
>

-- 





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