I just want to let you know that I developed a perl script to extract exadata real-time metric information based on cumulative metrics.
The main idea is that cumulative, instantaneous, rates and transition exadata metrics are not enough to answer all the basic questions.
That’s why the script has been created as it provides a better understanding of what’s is going on on the cells right now
More details (on how and why) here : http://bdrouvot.wordpress.com/2012/11/27/exadata-real-time-metrics-extracted-from-cumulative-metrics/
Please don’t hesitate to give your opinion and report any issue you may found with it.
Thanks for your message and support.
Are you incorporated the following also in your script ?
1. cellCLI>LIST METRICDEFINITION WHERE objectType='CELL' DETAIL
2. cellCLI>LIST METRICCURRENT WHERE objectType='CELLDISK'
3. cellCLI>LIST METRICHISTORY WHERE name like 'CL_.* and collectiontime > ''
Hope it helps...
No I just collect metrics based on this : list metriccurrent attributes name,metricObjectName,metricValue where metricType='Cumulative' and then I subtract "metricValue" between 2 snaps to get real-time informations.