This content has been marked as final. Show 2 replies
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/
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 :))