Category Archives: Exadata

Graphing Exadata cells metrics with Telegraf, InfluxDB and Grafana

Introduction As a picture is worth a thousand words, we may want to visualise the Exadata cells metrics. What if you could do it the way you want? build your own graph? Let’s try to achieve this with 3 layers: telegraf: to … Continue reading

Posted in Exadata | Leave a comment

Exadata cell metrics: Join the metrics and their descriptions on the fly

Introduction Cells metrics are very useful but their name are not so friendly. The name is a concatenation of abbreviations for the type of component, delimited by the underscore character. Then you have to understand the naming convention to understand … Continue reading

Posted in Exadata | Leave a comment

Extract Exadata cells historical metrics in CSV format

Exadata provides a lot of useful metrics to monitor the Cells and you may want to retrieve historical values for some metrics. To do so, you can use the “LIST METRICHISTORY” command through CellCLI on the cell. But as usual, … Continue reading

Posted in Exadata | Leave a comment

ASM Bytes Read and Smart Scan

Introduction I like to query the v$asm_disk_iostat cumulative view (at the ASM instance level) as this is a centralized location where you can find metrics for all the databases the ASM instance is servicing. One of its metric is: BYTES_READ: Total number … Continue reading

Posted in Exadata | 2 Comments

exadata_metrics.pl: “Month ’12’ out of range 0..11” dealing with the collectionTime attribute

Yesterday was the first of December and I detected an issue with the exadata_metrics.pl script when dealing with the collectionTime attribute. It produced: Month ’12’ out of range 0..11 at ./exadata_metrics.pl line 255 This is due to the fact that when using perl … Continue reading

Posted in Exadata, Perl Scripts, Presentations | Leave a comment

exadata_metrics.pl: New feature to collect real-time metrics extracted from cumulative metrics

I am a big fan of real-time metrics extraction based on the cumulative metrics: That is to say take a snapshot each second (default interval) from the cumulative metrics and computes the delta with the previous snapshot. I build such … Continue reading

Posted in Exadata, Perl Scripts | Leave a comment

Exadata Cell metrics: collectionTime attribute, something that matters

Exadata provides a lot of useful metrics to monitor the Cells. The Metrics can be of various types: Cumulative: Cumulative statistics since the metric was created. Instantaneous: Value at the time that the metric is collected. Rate: Rates computed by … Continue reading

Posted in Exadata, Perl Scripts, ToolKit | 1 Comment