PostgreSQL for the Oracle DBA, Part 4: Query Tuning and the PostgreSQL Planner
As an Oracle DBA venturing into the world of PostgreSQL, one of the most important areas to get comfortable with
Read More
Making Technology Bulletproof
PostgreSQL for the Oracle DBA, Part 3: Transaction Control, Locking, and Performance Insight
Now that we finished Part 2 on physical data structures, storage and processes, it’s time to work our way into
Read MorePostgreSQL for the Oracle DBA, Part 2: Physical Data Structures, Storage, and Processes
In the previous post, I covered some high-level areas around installation and architecture, but for this post, we’re going to
Read MoreOracle DBA to PostgreSQL, Part 1: Install and Architecture
As an Oracle DBA stepping into the PostgreSQL world, one of the first surprises you’ll encounter is during installation. If
Read MoreAn Oracle DBA’s Introduction to PostgreSQL – The New Reality
Back in 2004, I had my first run-in with PostgreSQL’s predecessor: Ingres. It was just another database platform for me
Read MoreKeynotes and Data Protection in the Age of AI
Over the last year, I’ve had the privilege of presenting keynotes and technical sessions to both the Oracle and SQL
Read MoreOracle Multitenant- Navigating CDB and PDBs Seamlessly
With Oracle Database 12c, Oracle introduced Multitenant Architecture, a major shift in how databases are structured and managed. This architecture
Read MoreOracle Data Guard: Disaster Recovery AND High Availability
In its traditional, (and free) configuration, Oracle Data Guard operates in an active/passive architecture. This incredibly well-designed and valuable solution
Read MoreThe Value of Cost: Oracle’s Optimizer
When you first begin your journey into Oracle performance tuning, you quickly discover that you’re not just working with databases,
Read MoreOracle RAC Monitoring: V$, GV$ and the Rest
Furthering on our Oracle Real Application Clusters (RAC) knowledge, we’re going to go deeper into what we watch for a
Read MoreOracle RAC: Monitoring and Preventing Performance-Tipped Evictions
After my last blog post on Oracle Real Application Clusters (RAC) I was asked to talk about both health and
Read MoreOracle RAC 101: Architecture, Configuration, and Real-Time Scalability
The request of me today was to start blogging on Oracle Real Application Clusters (RAC) so here we go, down
Read MoreA Year with Redgate, A Lifetime with Oracle
I was caught off guard last week when the “Congratulations on your work anniversary!” messages started rolling in on LinkedIn.
Read MoreReturning to the Oracle Community: Speaking Up, Holding Strong
Recently, I re-entered the Oracle community as a speaker, and I won’t lie, I felt some anxiety. I’d been away
Read MoreTroubleshooting ‘resmgr:cpu quantum’ and High CPU in Oracle
After publishing my last post on Oracle Wait Classes, I received a great question on LinkedIn: “How do you identify
Read MoreUnderstanding Oracle Wait Classes: The Key to Unlocking Database Performance
When we talk about optimization in Oracle, many DBAs immediately jump into metrics like CPU utilization, I/O throughput, or specific
Read MoreOracle Memory Management: Common Configurations, Parameters, and Monitoring
After the initial overview of memory monitoring in Oracle, particularly around the SGA and PGA, I wanted to take a
Read MoreNomad Internet: A Customer Cautionary Tale of Accountability in the Subscription Economy
Like many of us who took to the road during the pandemic, I relied on a variety of services to
Read More