OraEasy

Introduction: AWR (Automatic Workload Repository) is an Oracle performance monitoring feature that collects, processes, and stores database performance statistics. These statistics are used for problem diagnosis and self-tuning of the database. The collected data can be viewed through database views or generated as HTML or text reports, helping DBAs analyze the current performance state of the database in detail. Background Processes for AWR: MMON : Collects AWR statistics. MMNL : Writes ASH and AWR data to disk. Data Collected by AWR: AWR captures a wide range of performance related metrics, including: Object Statistics: Access and usage statistics of database segments. Time Model Statistics: Data from V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views. System and Session Statistics: Selected statistics from V$SYSSTAT and V$SESSTAT views. Active Session History (ASH) statistics. High-load SQL statements contributing significantly to database w...

Introduction: A switchover is a role reversal between the primary database and one of its standby databases. In this article we will see how to do Switchover activity in Logical Standby setup. Prerequisites: Logical standby should be configured and in sync. 30 mins downtime at database end. Environment: Server Primary Standby Hostname dcdb.oraeasy.com drdb.oraeasy.com OS OEL 9 OEL 9 SID ORADBDC ORADBDR Service Name ORADBDC ORADBDR Now proceed to Switchover activity step by step: 1. Check the sync between Primary and Standby. ==> Primary: SQL> select name,db_unique_name,database_role,open_mode from v$database; NAME DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE --------- ------------------------------ ---------------- -------------------- ORADB oradbd...