The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes.
The Oracle Optimizer determines the most efficient way to execute a SQL query by evaluating various potential execution plans and choosing the best one.
SQL Trace captures detailed performance data about SQL execution, which can be analyzed using TKPROF to identify bottlenecks and optimize query performance.
STATSPACK is a performance monitoring tool that captures a wide range of performance data at regular intervals, which can be used to analyze trends and identify performance issues.
ADDM automatically analyzes AWR data to identify performance bottlenecks and recommends actions to resolve them, helping to maintain optimal database performance.
