Compares PostgreSQL's pg_stat_wal metrics to Oracle's detailed redo logging instrumentation for database administrators.
A data professional shares her schedule and projects for PASS Data Community Summit, including keynotes, sessions, and a fun AI-powered PowerShell script.
Compares PostgreSQL's tuple-based MVCC and append-only updates with Oracle's in-place row updates and undo-based MVCC for database concurrency.
Compares Oracle and PostgreSQL wait analysis for database performance tuning, focusing on wait classes vs. event types.
A guide for Oracle DBAs on PostgreSQL transaction control, locking mechanisms, and performance monitoring basics.
A technical comparison of PostgreSQL and Oracle physical storage, memory architecture, and processes for database administrators transitioning between the two systems.
Oracle 19c Docker containers timeout with JDBC driver versions 19.3.0.0+, causing a 'Got minus one from read call' error. The fix is to set oracle.net.disableOob=true.
A historical account of Oracle's poor performance in a 1983 database benchmark and their alleged attempt to have the professor behind it fired.
