Automatic generation of Oracle standard AWR reports

Guidewire provides the means to generate an Oracle Standard AWR report automatically as you generate a Guidewire AWR report. To do so, ensure that you include report option Include native Oracle AWR report in the list of options against which to run the report. The PolicyCenter base configuration sets (checks) this option by default.

To generate a report with this option, the Oracle database user must have EXECUTE privilege for database package DBMS_WORKLOAD_REPOSITORY. If the database user does not have the required privilege, PolicyCenter does not generate a report and prints a message to the application log.

If the required privilege does not exist for the database user, do one of the following:

• Request that the database administrator grant the required privilege and rerun the report from Oracle AWR screen.
• Manually execute script oraclescripts.sql from the database server.

See also

• Generate Oracle standard AWR reports using a SQL script