Re: Doubt about Oracle Exadata Smart Flash

From: Lothar Flatz <>
Date: Sun, 18 Feb 2018 14:24:56 +0100
Message-ID: <>

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:


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


Received on Sun Feb 18 2018 - 14:24:56 CET

Original text of this message