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.
A Java developer answers community questions about working on Oracle's Java Platform Group, the Inside Java Newscast, and team collaboration.
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.
Explains how to emulate SQL's FILTER clause for JSON aggregate functions in Oracle, addressing NULL value handling in JSON arrays and objects.
Explains Oracle-specific SQL techniques for retrieving the top 1 row per group, covering KEEP syntax, ANY_VALUE(), and object/JSON workarounds.
jOOQ 3.18.0 release adds enhanced SQL diagnostics, SQL/JSON support, Oracle/PostgreSQL array features, and R2DBC 1.0 integration.
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 report on the virtual DOAG 2021 conference, covering talks about running WebLogic on Azure and the future of Jakarta EE.
Summary of the Jakarta EE community's turmoil over the javax package name and trademark issues after Oracle's transfer of Java EE.
Introducing NHInsights, a custom NHibernate driver for Oracle that integrates with Application Insights to track database query dependencies.
A historical account of Oracle's poor performance in a 1983 database benchmark and their alleged attempt to have the professor behind it fired.
