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. Enterprise Manager Best Practices
  6. AWR Warehouse Credentials

AWR Warehouse Credentials

When configuring an Enterprise Manager target as the AWR Warehouse Repository, select two credentials:

  • Database credentials–AWR Warehouse requires SYSDBA credentials.

  • Database host credentials–select credentials that have write permission on the dump file staging ___location. The default staging ___location is the agent state directory to which the agent user has the necessary permissions.