Author: Jose Rodriguez

So, here is the thing. We have a customer running a 11.2 Single Instance Oracle database on Windows. I know the version is a bit old and Windows may not be the most common choice to run an Oracle database,…

It’s been a couple weeks now, and the dust has settled but not the sentiment. I am talking about my very first public presentation performed at Spain Oracle Users Group (SPOUG) during the Technical SPOUG Day 2018 on September 25th….

The short question While preparing a presentation I am giving this year about HugePages, a colleague of mine at Pythian posed an interesting question: Does Oracle use HugePages for PGA? The short answer No, it doesn’t. The long question We…

It was a Thursday morning. I started my day at work and found out that I was tasked with running a test upgrade to 11.2.0.4 right on Friday. This is just to make clear that I did not have much…

This is the same plugin that Alex Gorvachev created back in the day. I’ve simply modified it to be compatible with both 12c and 13c versions. I created this in response to a comment on the blog about issues deploying…

So, what’s up? In case you don’t know, my co-worker Gleb Otochkin has written a couple of blog entries about HugePages’ support in different cloud providers here and here. Given that I am preparing a presentation about HugePages, I reached…

The idea Due to the nature of my consulting work, I mostly work in Linux environments and use bash for scripting. But in some cases, I hit a Windows server hosting an Oracle database and all the fancy bash scripts…

Issues during the switchover to standby database The beginning So, there we were attending to our jobs and tending to our customers when an emergency alert came in: a production server had gone down. All bells and whistles were sounded…

The trouble with a feature that kicks in without announcement So, there I was the other day creating a procedure to obfuscate data for one of our customers, you know: GDPR is coming!! The idea is pretty simple: a PL/SQL BULK…

We tend to configure a server following Oracle best practices for the kernel parameters, but what once was a server of a couple instances, soon becomes a huge and heavy environment with four, six or ten instances running on it…