Exadata General (MOSC)

MOSC Banner

Effective attributes for being cached in the Exadata Smart Flash Cache

edited Oct 16, 2013 7:55PM in Exadata General (MOSC) 3 commentsAnswered
Which three attributes are likely to result in data being cached in the Exadata Smart Flash Cache?
   1.CELL_FLASH_CACHE attribute on the data object
   2.CACHE hint In the SQL statement
   3.Small data less than 128 KBs
   4.Control file I/Os

I missed above question, and answer is 1,2,3.  I thought 1,3,4.

Hereby I have questions below.

Is CACHE hint effective for data being cached in the Exadata Smart Flash Cache?  In the standard Database, the CACHE hint is effective for data being kept in Buffer Cache.

In other words, Is CACHE hint in Exadata Environment effective for data to be kept in Buffer Cache on the database server instead of Smart Flash Cache?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center