Why Oracle DBAs Must Rethink PostgreSQL’s work_mem and Cursor Sharing

The article explains how Oracle DBAs transitioning to PostgreSQL often misinterpret work_mem and cursor sharing, showing how improper settings can drastically change execution plans, increase query time, and cause performance issues, while also highlighting differences in memory management and plan caching between the two systems.

DBAOraclePostgreSQL

0 likes · 8 min read

Why Oracle DBAs Must Rethink PostgreSQL’s work_mem and Cursor Sharing

ITPUB

Jul 5, 2018 · Databases

Mastering Oracle Cursors: Views, Parameters, and Performance Tuning

This article explains Oracle cursor concepts, the key V$SQL and V$SQLAREA views with their most important columns for tuning, how open‑cursor limits and the CURSOR_SHARING parameter affect execution plan sharing, and provides practical guidance for DBA performance optimization.

CursorDatabase TuningOpen Cursor

0 likes · 14 min read

Mastering Oracle Cursors: Views, Parameters, and Performance Tuning

dbaplus Community

Feb 16, 2016 · Databases

Understanding Oracle SQL Hard and Soft Parsing: Full Process Explained

This article breaks down Oracle's SQL parsing workflow into four stages—syntax check, semantic check, parse phase, and execution phase—detailing how hard and soft parses differ, why cursors may not be shared, and common reasons for parsing failures.

OracleSQL parsingcursor sharing

0 likes · 7 min read

Understanding Oracle SQL Hard and Soft Parsing: Full Process Explained