Re: Doubt about Oracle Exadata Smart Flash

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_at_gmail.com> 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
>

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