Transportable Tablespaces were first introduced in Oracle 8i to allow entire tablespaces to be copied between databases in the time it takes to copy the datafiles. In Oracle 8i, the major restriction was that both source and target databases had to use the same block size. With the introduction of multiple block sizes in Oracle […]
Oracle Database 12c Release 1 (12.1) introduced a modern and unified way to manage encryption keys, keystores, and secrets through the ADMINISTER KEY MANAGEMENT command.This replaced the legacy commands: The Oracle documentation often uses both wallet and keystore interchangeably, but the preferred and forward-looking term is keystore, aligning with Java standards. Understanding TDE in a […]
In Oracle Database 19c, a powerful new feature arrives: Real-Time Statistics. Its main goal is to reduce the chance that the optimizer makes poor decisions because of stale statistics — especially in scenarios where data changes rapidly between scheduled statistics gathering cycles. Real-time statistics build on earlier features like online statistics gathering for bulk loads […]
Oracle Database performance tuning is a dance of insight and intuition, a symphony of numbers and narratives.In this blog, we unravel the Automatic Workload Repository (AWR) report, one of the DBA’s most powerful instruments for diagnosing bottlenecks, isolating pain points, and transforming sluggish systems into seamless symphonies. 1. What Is the AWR Report? The Automatic […]