PostgreSQL for the Oracle DBA, Part 5: Understanding Wait Analysis
Oracle: Wait Classes & Events As discussed in an earlier blog post, Oracle groups wait events into wait classes like
Read More
Making Technology Bulletproof
oracle
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 MorePostgreSQL 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 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 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 MoreDesigning for Multi-Platform Databases: A SME’s Perspective
When building products that interact with multiple database platforms, the complexity can be both a challenge and an opportunity. For
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 MoreVolume Snapshots and Oracle Home Considerations
In the midst of us needing to do more with less every day, many of us are incorporating clones to
Read More