Oracle DBA

Oracle Exadata represents the pinnacle of Oracle Database performance, engineered specifically for high-speed transaction processing and analytics workloads. To truly leverage the power of Exadata, understanding advanced performance tuning techniques is essential. This article explores critical tuning methodologies that database administrators (DBAs) and architects can implement immediately. Smart Scan Optimization Oracle Exadata’s unique Smart Scan […]

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 […]

Oracle Database 19c represents the culmination of years of innovation in the Oracle 12c product line, delivering a suite of enhancements that elevate the humble SELECT statement from a straightforward data retrieval mechanism into an intelligent, self-optimizing, and JSON-aware powerhouse. In this deep-dive blog post, we’ll explore each of these advancements in detail, illustrate them […]

In Oracle Database 19c, the optimizer introduces a powerful feature called SQL Quarantine. This feature prevents recurring execution of problematic SQL statements that consume excessive resources or cause performance degradation. By automatically detecting high-resource SQL statements and placing them into quarantine, Oracle ensures that such queries cannot repeatedly impact system performance. This feature is especially […]