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. Source Database Credentials

Source Database Credentials

Before adding source database targets to the AWR Warehouse Repository, set Preferred Credentials (Normal Credentials should be sufficient) for each of the source databases and their hosts. This facilitates adding multiple source databases at once (select multiple databases in the Search and Select: Database dialog).

  • Database credentials–the database user requires the following:

    • DBA role

    • Execute privileges on SYS.DBMS_SWRF_INTERNAL package

  • Database host credentials–the user should be the same as the agent user.