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

ITPUB

Aug 12, 2016 · Databases

Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters

This article explains Oracle cursor concepts, details the key V$SQL and related views, highlights crucial columns for performance tuning, and describes important parameters such as open_cursor and cursor_sharing, helping DBAs optimize SQL execution and manage shared pool memory effectively.

CursorDatabase PerformanceOracle

0 likes · 13 min read

Unlock Oracle Cursor Insights: Master V$SQL, V$SQLAREA, and Tuning Parameters

ITPUB

May 27, 2016 · Databases

How to Log Every Executed Oracle SQL Statement with v$sql and Automated Jobs

This guide explains why a numeric column turned null, compares using the volatile v$sql view with a permanent logging solution, and details step‑by‑step how to create a tablespace, logging table, stored procedure, and scheduled job to capture all Oracle SQL statements.

Database LoggingJob SchedulingOracle

0 likes · 5 min read

How to Log Every Executed Oracle SQL Statement with v$sql and Automated Jobs