Installation/Configurations12c

Oracle Real Application Clusters (RAC) Global Cache Tuning : Introduction : Everything covered so far – blocking, deadlocks, ADDM, SPA, AWR Compare Periods, SQL Monitor, 10053, Database Replay, ASH – …

Oracle Active Session History (ASH) : The Sampling Model for Transient Performance Problems : Introduction : AWR and ADDM operate on snapshots. By default, AWR captures a snapshot once per …

Oracle Database Replay: Full-Scale Workload Testing for Changes and Migrations : Introduction : Every DBA eventually faces a change that is too risky to test with a handful of SQL …

Oracle 10053 Optimizer Trace: Seeing Inside the Cost-Based Optimizer : Introduction : Every time Oracle performs a hard parse of a SQL statement, the Cost-Based Optimizer (CBO) goes through a …

Oracle SQL Monitor : Real Time Execution Plan Monitoring : Introduction : SQL Monitor is a diagnostics tool that tracks long-running SQL statements while they are still executing. It does …

Oracle SQL Performance Analyzer (SPA) : Predicting the Impact of Changes on SQL Workloads Introduction As a DBA, you often face a decision: the database needs to be upgraded, an …

Introduction : When you manage an Oracle database in production, performance problems are inevitable. A query suddenly slows down, users start complaining, and you need to figure out what went …

Introduction – Oracle Database Blocking Sessions In Oracle Database, blocking occurs when one session holds a lock on a resource (typically a row or table) and another session attempts to …

Part I — Understanding Data Guard & High Availability 1.1  What Is High Availability, and Where Data Guard Fits High availability is the discipline of keeping a database reachable through failures …

Part I — Understanding Database Links 1.1  What Is a Database Link? A database link is a schema object that stores the connection details needed to reach another database, so that …