Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

smart flash cache algorithm

897831Apr 16 2012 — edited Apr 20 2012
I'd like to understand exactly how smart flash cache algorithm works.
I’ve read the Oracle white paper on smart flash cache. It says following:
Exadata Smart Flash Cache provides an automated caching mechanism for frequently-accessed data in the Exadata Database Machine.
What is the algorithm to figure out "frequently accessed data”?

It also say following -
The Oracle Database and Exadata Storage Server Software work closely together to cache frequently accessed data.
When the database sends a read or write request to Exadata Storage Server, it includes additional information in the request about whether the data is likely to be read again and therefore whether it should be cached.
Again what's the algorithm to figure out that data is likely to be read again?
Does it simply cache all random reads against tables and indexes and ignores all sequential reads, scans, writing backups and mirrored blocks?

I’ve also read that, Exadata tags each DB I/O is with metadata indicating I/O type which influence caching . Can somebody shed light on what are various I/O types and which ones are cached?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2012
Added on Apr 16 2012
4 comments
429 views