• Just a Serverless Blog Experiment!

    This is not really a propper blog post. I’m just experimenting with serverless blog ideas on GCP.

    Read on →

  • 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!

    getMOSPatch

    getMOSPatch

  • 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 →