Export AWR Logs: Oracle Step-by-Step

1 year ago
Jackson Davis
2 minutes

To export AWR logs, you can use SQL*Plus or Enterprise Manager to follow these steps:

  1. Login to the Oracle database using an account with administrator privileges.
  2. Open a SQL*Plus session or log in to the Enterprise Manager console.
  3. View the ID of the current database instance:
  4. Choose the DBID from the V$DATABASE table.
  5. Check the start and end timestamp of the AWR logs that need to be exported. You can use the following query to retrieve the relevant information:
  6. Choose the SNAP_ID, BEGIN_INTERVAL_TIME, and END_INTERVAL_TIME
    in the DBA_HIST_SNAPSHOT table.
  7. Please make a note of the start and end timestamps for the AWR logs to be exported.
  8. Export AWR logs using the following command:
  9. Run the following in SQL*Plus:
    @$ORACLE_HOME/rdbms/admin/awrrpt.sql

    Follow the prompts to enter the database instance ID, start, and end time stamps.

  10. In the Enterprise Manager console:
    a. Go to the “Databases” section, then select “Performance” > “AWR” > “AWR Reports”.
    b. On the “AWR Reports” page, choose the time range of the AWR report to export.
    c. Click the “Generate Report” button to generate the AWR report.
  11. Save the generated AWR report to the desired location.

The steps above will assist you in exporting AWR logs for analysis and performance optimization. Please choose the appropriate tools and methods based on your needs.

bannerAds