Author: Jose Rodriguez

Solving An Uncommon Oracle Error Code – ORA-01041

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,…

Read More >

First Time Presenter, What a Feeling!

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….

Read More >

Does Oracle allocate PGA in HugePages?

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…

Read More >

How to Test an Oracle Database Upgrade using a Physical Standby

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…

Read More >

MySQL Plugin For Oracle Enterprise Manager 13c Cloud Control

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…

Read More >

HugePages for Oracle Database in Azure Cloud

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…

Read More >

An Oracle “oraenv” script solution for Windows with PowerShell

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…

Read More >

Fun with Oracle Data Guard Broker

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…

Read More >

Scalar subquery caching in action

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…

Read More >

The importance of Oracle database related kernel parameters (aio-max-nr) (with bonus track)

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…

Read More >