Author: Jose Rodriguez

Save time with this quick OCI CLI installation

This is more of a personal reminder than anything else, but hopefully it helps save some time for others trying to install the OCI CLI on their local Linux machines. The idea is to have a very basic set of…

Read More >

An Oracle-based approach to the “taxi fare” prediction problem – episode 2

This is the second part of the series on the Taxi Fare prediction problem from an Oracle perspective. You can read Episode 1 here. In this Episode, I will put our model to work. That is, I will show several…

Read More >

An Oracle-based approach to the “taxi fare” prediction problem – episode 1

Although I haven’t produced a lot of posts, those I have produced were always strictly related to the Oracle RDBMS as a whole product, basically a record of interesting findings that came up during my day-to-day job. Now, this is…

Read More >

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 >
Page 1 of 212