â– Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes.
â– Automatic Database Diagnostic Monitor (ADDM) analyzes the information collected by the AWR for possible performance problems with the Oracle database.
â– SQL Tuning Advisor allows a quick and efficient technique for optimizing SQL statements without modifying any statements.
â– SQLAccess Advisor provides advice on materialized views, indexes, and materialized view logs.
â– End to End Application tracing identifies excessive workloads on the system by specific user, service, or application component.
â– Additional advisors that can be launched from Oracle Enterprise Manager, such as memory advisors to optimize memory for an instance. The memory advisors are commonly used when automatic memory management is not set up for the database. Other advisors are used to optimize mean time to recovery (MTTR), shrinking of segments, and undo tablespace settings.
â– The Database Performance page in Oracle Enterprise Manager displays host, instance service time, and throughput information for real time monitoring and diagnosis. The page can be set to refresh automatically in selected intervals or manually.
â– V$ Performance Views