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.
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
I do not know of any. I’m going to have at least a few blog entries on the topic if that is any consolation.
Don’t know if your are talkting about the Exadata Docu or the F20 Flash Card Docu. You can find some infos here
http://www.oracle.com/us/products/servers-storage/storage/disk-storage/043966.html
and there is a link on docs.sun.com and than search for F20
may be just to be very precise you should call the Exadata Smart flash cache “Sun Flash Accelerator F20 PCIe Card” 😉
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.
@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.