Monthly Archives: May 2013

Retrieve and visualize ASM Disk Group Usage per database with R

If you are using Oracle Enterprise Manager and ASM, then you may already be familiar with the following page that displays the Disk Group Usage per database for a particular Disk Group: And it is most likely that you don’t … Continue reading

Posted in R scripts | 1 Comment

TAF is not working on Rac One Node in case of node failure ? Well it depends

Martin Bach did a good study of Rac One Node capability and especially of what happens with session failover during a database relocation or during a node failure into this blog post. He showed us that: during a database relocation (initiated manually with srvctl … Continue reading

Posted in Rac | Leave a comment

ASM Preferred Read: Collect performance metrics thanks to my amsiostat utility and SLOB 2

Some times ago I provided a way to see the ASM Preferred Read feature in action thanks to Kevin Closson’s SLOB kit and my asmiostat utility into this blog post. Since that time Kevin released SLOB 2. One of its … Continue reading

Posted in Perl Scripts | Leave a comment

Diagnose Adaptive Cursor Sharing (ACS) per execution for non monitored sql

Into this blog post: Diagnose Adaptive Cursor Sharing (ACS) per execution in 11.2  I provided a way to check if ACS came into play per execution of a given sql. You should read the previous post to understand this one. … Continue reading

Posted in Perl Scripts | Leave a comment

Diagnose Adaptive Cursor Sharing (ACS) per execution in 11.2

As you know oracle introduced a new feature “Adaptive cursor sharing (ACS)”  in 11g. You can find a very good explanation of what it is into this Maria Colgan’s blog post. So, as Maria said: “A bind aware cursor may … Continue reading

Posted in Perl Scripts | 3 Comments