Posts

Showing posts with the label PERFORMANCE TUNING GUIDE

PERFORMANCE TUNING GUIDE

                            ORACLE 19c DATABASE PERFORMANCE TUNING GUIDE Step-by-Step Reference for DBAs and Performance Engineers      Step 1: Establish a Performance Baseline   Before tuning anything, you must understand how the database currently behaves. A baseline gives you a reference point to measure improvement.   1.1  Enable the Automatic Workload Repository (AWR) AWR is the primary performance data collection mechanism in Oracle 19c. Verify it is licensed and active: SELECT * FROM dba_hist_wr_control;   Set the snapshot interval and retention period: BEGIN   DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(     retention => 43200,   -- 30 days in minutes     interval  => 60       -- Snapshot every 60 minutes   ); END; /   1.2  Take a Manual AWR Snapshot Capture an...