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