Generate Oracle standard AWR reports using a SQL script

About this task

Guidewire provides a SQL script that you can execute against the database server to generate the Oracle Standard AWR reports.

Procedure

  1. Log into Guidewire PolicyCenter using an administrative account.
  2. Navigate to the Server Tools Info Pages > Oracle AWR Information screen.
  3. Generate and download an AWRReport.zip file as described in Generate Guidewire AWR reports from PolicyCenter.
  4. Extract the contents of the AWRReport.zip file to a local directory.
  5. Navigate to the following directory:
    • AWRInfo > sqlscripts
  6. Execute the following script against the database server:
    • oraclescripts.sql
    Executing this script creates an Oracle Standard AWR report.