Wednesday, October 16, 2013

How to query Exadata's Storage Cell activity

Yesterday we learned how to go up and down the chain of disks to identify problems and information for Exadata cells, but today in our blog spotlight you'll learn from Tanel about v$cell_thread_history!  He equates this to a database ASH (Active Session History) type of table/report, but only for your cell server and apparently the last 10 minutes of activity on a heavily used cell.  Since I don't really have to dig into Exadata cell problems (yet) this script might gather some dust, but when I have some free time or see the glimmer of a problem on a single cell you can bet I'll have this in my toolkit to use when that day comes.  Another great script for Exadata!

No comments:

Post a Comment