• The getMOSPatch V2 is Here!

    Just wanted to let you know that I’ve released the 2nd version of getMOSPatch - a tool for downloading Oracle patches directly from My Oracle Support to your server without having to visit the support site. It’s now written in java and thus it’s platform independent! Read more about it on my Pythian blog post here, and get it directly from GitHub here!

    Read on →

  • Simple Script for Real-Time Wait Event Monitoring

    What do you do when you’re dealing with an ongoing performance issue and somebody’s watching over your shoulder and asking something like “Hey, has our commits’ response time become any better by now?”. Or, if you’re observing a spike in IO requests that doesn’t last for too long, and you want to see how much worse the response times of db file sequential read events gets? Writing queries at these moments require time which one doesn’t have, so I’ve written a script that I already use in situations like these

    Read on →

  • Internals of Querying the Concurrent Requests Queue - Revisited for R12.2

    Once upon a time I wrote about the Internal Workflow of an E-Business Suite Concurrent Manager Process. Many things have changed since that blog post, from which the most obvious change was the release of Oracle e-Business Suite R12.2. So, I decided to check if the way how the concurrent manager queues were processed by concurrent manager processes were still the same. My main goal was to see if the manager processes still don’t attempt any way of coordination to distribute the requests among them.

    Read on →

  • SQL Profiles vs. SQL Plan Baselines

    Recently one of my customers asked, what would happen if we had SQL Profile set up for a particular query to make sure it uses the correct execution plan, as well as an existing SQL Plan Baseline for the same query? What would happen if these two features would like the SQL statement to use different execution plans? Which one would win? I hesitated to answer immediately, although the answer seams obvious now. Look how I came to the answer!

    Read on →

  • Do AWR Reports Show the Whole Picture?

    AWR report is a great source of aggregated information on top activities happening in our databases. I use data collected in AWR quite often, and obviously the easiest way of getting the data out from the AWR is by running the AWR report. In most cases that’s not an issue, but there are certain scenarios when it hides the information one is looking for, just because of how it’s designed.

    Read on →