Effective Tuning Goal
- Specific
- Measurable
- Achiveable
- Cost effective
Goals are also derived from related Service Level Agrements.
Key v$ views
============
V$sysstat
v$sesstat
v$system_event
v$session_event
v$session
5.2 Overview of the Automatic Workload Repository
=================================================
The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.
6.2 Automatic Database Diagnostic Monitor
=========================================
The Automatic Database Diagnostic Monitor (ADDM) provides a holistic tuning solution. ADDM analysis can be performed over any time period defined by a pair of AWR snapshots taken on a particular instance. Analysis is performed top down, first identifying symptoms and then refining them to reach the root causes of performance problems.
Unit 7
Automated Maintenance Tasks
===========================
In 11g auto stats gathering is more flexiable, allows you to change the % of staleness or auto etc.
