Monthly Archives: September 2013

Flush a single SQL statement and capture a 10053 trace for it

Just a quick one, to share a simple sql script in case you need to trace the optimizer computations for a single SQL statement. As you know, Oracle Database 11g, introduced a new diagnostic events infrastructure, which greatly simplifies the … Continue reading

Posted in ToolKit | 2 Comments

RAC Attack at Oracle OpenWorld 2013: Don’t be afraid !

You’ll attend Oracle OpenWorld 2013 and: You want to install a 12c RAC using oracle Virtual Box on your laptop. Or you just want to have a talk or share your experience with some people around this technology. So, you … Continue reading

Posted in Rac | 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

Find out the most physical IO consumers through ASM in real time

Well, suppose you are using ASM and it is servicing a lot of databases per machine. Suddenly the number of IOPS increased in such a way that your sysadmin/storage guy warn you up (I know this is not the real … Continue reading

Posted in ASM | Leave a comment