In earlier versions of Oracle Database, statistics were collected mainly through scheduled jobs using DBMS_STATS. This often resulted in stale statistics between collection intervals, especially in OLTP environments with frequent DML operations. Oracle 19c introduces Real-Time Statistics, a feature that collects optimizer statistics immediately during DML operations such as INSERT, UPDATE, MERGE, and CREATE TABLE […]
In Oracle Database, temporary tablespaces play a critical role during SQL execution. Whenever a query involves sorting, joining, aggregation, index creation, or operations that cannot be handled entirely in memory (PGA), Oracle uses temporary tablespaces to store intermediate results. As a DBA, understanding how to monitor and troubleshoot temporary tablespace usage is essential to avoid […]
In high-throughput Oracle environments, cursor sharing is a pivotal lever for controlling hard parse overhead, shared pool pressure, and overall scalability. The central control is the initialization parameter CURSOR_SHARING: This article illustrates not just how cursor sharing behaves, but how to monitor it rigorously using Oracle’s dynamic performance views. 1) Environment and Safety First Run […]
In the silent architecture of the Oracle Database, every line of PL/SQL code carries weight. Performance issues arise not with a roar, but with a whisper—a process that once danced now stumbles, and somewhere deep in the code, time leaks away. As Oracle professionals, our calling is to seek out these shadows and bring them […]