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.
SQL Trace captures detailed performance data about SQL execution, which can be analyzed using TKPROF to identify bottlenecks and optimize query performance.
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.
ADDM automatically analyzes AWR data to identify performance bottlenecks and recommends actions to resolve them, helping to maintain optimal database performance.
