Working with consulting clients is rewarding, interesting, and challenging. In discussion with some of my colleagues, I’ve noticed the same performance challenges come up over and over again across clients with completely different hardware, industry verticals, levels of staff seniority,…

Once I had done this, I created a property file to be used during the patching activities so I wouldn’t have to input the Weblogic information over and over. The next step was to analyze whether this patch was applicable…

A brief background on RAM cache or in-memory OLTP acceleration In this post I will present a feature — to simplify let’s call it RAM cache — introduced in Oracle Exadata Storage Server image 18.1. You’ve probably heard a lot…

With Oracle Data Guard promising high availability, data protection and disaster recovery for enterprise data, it’s useful to understand the Data Guard command-line interface (DGMGRL) which enables you to control and monitor a Data Guard configuration from the DGMGRL prompt…

This will be a short entry, but hopefully, it will help if you face the error “ORA-01722: invalid number” while doing an upgrade. Today I was doing an Oracle RDBMS upgrade from 12.2 with DST 34, to 19.7 with DST…

If you have a New Relic Infrastructure Pro license, and unmonitored MySQL servers, there’s now an easy solution at your fingertips. With the New Relic MySQL integration you can monitor and graph almost any detailed metric you could possibly want….

“We have many disparate data sources and we’re having a hard time getting a global view of all our data across our organization.” “Our data is currently all in <enter data warehouse name here> and we want to migrate it…

In January 1915, polar explorer Ernest Shackleton’s ship became trapped in ice near Antarctica. For the next two years, he kept his crew of 27 men alive on a drifting ice cap, before leading them to safety. In this article…

At Pythian, we pride ourselves in assisting and empowering our clients. We strive to understand the needs of each customer and to teach customers to make the most of their resources. Experience has shown that the best way to learn…