Pardon Me, Where Is That Flash Cache? Part I.

Flash is Flash is Flash, Right?

I was recently catching up on my reading of Jonathan Lewis’ blog when I read his post about Flash Cache. Jonathan’s post contained a few comments on the matter and then refers to Guy Harrison’s post on the topic.

After reading both of those posts I am now convinced more than ever that there is significant confusion over Flash Cache where Oracle Database 11g Release 2 is concerned. Both Jonathan and Guy state that Database Flash Cache (a.k.a. Database Smart Flash Cache) is an Exadata-only feature liberated for use in non-Exadata environments. I need to point out that this is not correct. However, when extremely smart folks are getting it wrong I think it is safe to say that there must not be enough information available.

Distant Cousins

From the initial release of Oracle Database 11g Release 2 the Database Flash Cache feature has had nothing in common with Exadata Smart Flash Cache other than Flash technology happens to be at the very center. In fact, it would be quite difficult for them to be any more dissimilar than they are. Put simply:

  • Database Flash Cache is an extension of the SGA that resides in Flash. Only data buffered in the SGA can make its way into the Database Flash Cache. The data is essentially “aged” out and written by DBWR into the Flash Cache device file.
  • Exadata Smart Flash Cache is PCI Flash  in Exadata Storage Server used for intelligent, adaptive cache. That is to say that regardless of whether the primary buffering of data is in the SGA or PGA, Exadata Smart Flash Cache is down-wind caching data based upon demand.

The words of the Oracle Database 11g New Features list introduces Database Flash Cache as follows:

Database Smart Flash Cache

Database Smart Flash Cache is an optional memory component that you can add if your database is running on Solaris or Oracle Enterprise Linux. It is an extension of the SGA-resident buffer cache, providing a level 2 cache for database blocks. It can improve response time and overall throughput.

As for Exadata Smart Flash Cache, there is a good white paper on the topic available here.

Part II can be found here.

8 Responses to “Pardon Me, Where Is That Flash Cache? Part I.”

  1. 1 Leandro December 10, 2009 at 12:57 pm

    I was looking for some documentation on the Smart Flash Cache, and all the info I could get was the one available in the product documentation.

    Do you know if there is some additional info out there?

    Best regards

  2. 4 Alexander Kern August 4, 2010 at 11:54 am

    may be just to be very precise you should call the Exadata Smart flash cache “Sun Flash Accelerator F20 PCIe Card” 😉

  3. 5 Kim Pearson May 25, 2012 at 12:01 pm

    Question: has ANYONE actually confirmed 1.5M IOPS on Exadata (other than the not-so-helpful Oracle data sheets)? I would like to know if SLOB, ORION, or any other tool known to dba-kind has been used to ascertain whether or not that is pure hype/fiction, or whether they can actually get that kind of performance in a practical testing situation.

    • 6 kevinclosson May 29, 2012 at 3:27 pm

      @Kim Pearson : Hi Kim. I’ve don’t over a million with an approach similar to SLOB on my own Exadata Lab gear when I was in the development organization there. Some tweaks have brought that number up in the interim. Exadata can sustain the datasheet numbers (1.5 million) Oracle foreground process reads per second. Readers know I don’t mince words regarding Oracle marketing exaggeration and quickly point out said exaggerations when I see them. Exadata’s ability to sustain 1.5 million random single block read IOPS is no exaggeration.

  1. 1 Flash cache, exadata et 11GR2 « Trackback on January 8, 2010 at 5:24 pm
  2. 2 Kerry Osborne’s Oracle Blog » Blog Archive Oracle Exadata V2 - Flash Cache - Kerry Osborne’s Oracle Blog Trackback on October 19, 2010 at 12:52 am

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.


I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon. In other words, I work at Amazon, but this is my own opinion.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 743 other subscribers
Oracle ACE Program Status

Click It

website metrics

Fond Memories


All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

%d bloggers like this: