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

    Kevin,
    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
    Leandro

  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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s




EMC Employee Disclaimer

The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.

This disclaimer was put into place on March 23, 2011.

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

Join 1,948 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2013. 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.

Follow

Get every new post delivered to your Inbox.

Join 1,948 other followers

%d bloggers like this: