Eriovaldo,
As regards the syntax for using
the smart flash at the table level,
here it is :
alter table <table name>
storage
(flash_cache keep)
or
(flash_cache none)
or
flash_cache default)
Best,
Rajeev
On Feb 18, 2018, at 7:48 AM, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
wrote:
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