Multiplatform Reality Checks: pg_stat_wal vs. Oracle Redo Metrics
For anyone who has spent years tuning Oracle redo, the first time you look at PostgreSQL’s pg_stat_wal view may feel
Read More
Making Technology Bulletproof
Oracle Basics
Oracle 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 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 MoreOracle Internals- Oracle Memory
When describing Oracle features to folks that are new to the platform or coming from other database platforms, I found
Read MoreRunning Oracle on Windows: An Island Unto Itself
For many DBAs, the thought of running Oracle on a Windows OS induces a collective cringe. Even for someone like
Read MoreOracle Architecture – Bridging the Old to the New
I’m passionate about making technology easier to understand, a mission I’ve pursued on my blog since 2008. However, I’ve faced
Read More