In Oracle 19c, enhancements in the Data Guard Broker enable DBAs to set, reset, and display database initialization parameters directly through the broker interface. These commands allow parameter changes to take effect immediately on the active database (or standby, or Far Sync) without first editing the broker configuration file. This article explains these new commands, […]
Ranking functions are part of SQL analytic functions and are widely used in reporting, analytics, and business intelligence. The most common ones are RANK, DENSE_RANK, and ROW_NUMBER. While they seem similar, their behavior differs when handling duplicate values. Let’s explore them through practical examples. Example 1: Ranking Employees by Salary within Each Department Here we […]
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 […]
What is Point-in-Time Recovery? Point-in-Time Recovery is a technique to restore a database to a specific moment in the past. Unlike complete recovery (which applies all redo/archived logs until the most recent commit), PITR deliberately stops recovery at a chosen point. Demo Scenario Let’s simulate a common situation: Step 1: Setup and Insert Data At […]