Doubt about Oracle Exadata Smart Flash
Date: Sun, 18 Feb 2018 09:48:36 -0300
Message-ID: <CAJdDhaNx+1nsV+qJ-E1X_H_U8OkKNDtWV_79uE7-sG5pJNVrGg_at_mail.gmail.com>
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
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-lReceived on Sun Feb 18 2018 - 13:48:36 CET