2 Replies Latest reply on Mar 20, 2013 5:11 PM by marksmithusa

    Any Dynamic Views for (Exadata) Flash Cache Usage?


      Despite it being one of the major selling points of Exadata (especially from X3 onwards), I'm struggling to find much information on our usage of the Exadata Smart FlashCache (I'm running RDBMS BP7 on a V2 quarter-rack).

      I can verify usage of the FlashCache by checking whether the object has been 'pinned' to the FlashCache via DBA_SEGMENTS and I can check for FlashCache usage by querying gv$sysstat (and even v$mystat), but are there other views that I could use? It seems a bit strange for Oracle not to provide the DBA all that much insight into their usage of this feature...

        • 1. Re: Any Dynamic Views for (Exadata) Flash Cache Usage?
          Marc Fielding
          Hi Mark,

          My colleague Christo Kutrovsky put together a clever script to gather this info from storage servers and to access it as an external table: http://www.pythian.com/blog/whats-in-your-exadata-smart-flash-cache/


          • 2. Re: Any Dynamic Views for (Exadata) Flash Cache Usage?
            That's really cool! I did read that web page on my (slow) way to figuring out there wasn't a performance view in the database that would help.

            I do a similar sort of thing already but with different metrics: I convert the output of cellcli commands (disk errors, cell temps, alerthistory, etc) into SQL which I then run against some analytical/monitoring tables I have in a schema. There's a lot of good info in cellcli, but I guess there's no corresponding database dynamic view.

            Thanks for the tip (and thank you to your colleague for the link :))