Monthly Archives: November 2012

Exadata real-time metrics extracted from cumulative metrics

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 | Tagged , , | Leave a comment

Perl Scripts Library

A small post to let you know that this page has been added to the blog. This page reference all the perl scripts that will be used into this Blog and each of them will be linked to  a practical case. … Continue reading

Posted in Perl Scripts, ToolKit | Tagged | Leave a comment

Measure oracle real-time I/O performance

Did you already need to measure real-time I/O performance of an oracle database ? AWR could provide an answer for historical period of time but what’s about:  what is going on on my database right now ? To measure real-time … Continue reading

Posted in Perl Scripts, ToolKit | Tagged , , , | 5 Comments

Link sql_id and oracle stats

How many times working on a performance issue, finding the Top SQL and Top Waits event has not been enough to understand what’s going on ? Sometimes you have to diagnose more in depth thanks to the Oracle stats reported … Continue reading

Posted in ToolKit | Tagged , | 2 Comments