1. Get Started with Performance Tuning
  2. Reactive Database Tuning
  3. Using Automatic Workload Repository Warehouse for Generating Performance Reports
  4. AWR Warehouse Best Practices
  5. Database Best Practices
  6. Access Control

Access Control

Ensure that users do not have direct access to the warehouse database as this will bypass the Enterprise Manager security model. The AWR Warehouse console in Enterprise Manager has an access control mechanism to control who can view data in the AWR Warehouse and for which source databases.