The Oracle Statspack screen

The Server Tools Oracle Statspack screen provides a means to download HTML reports based on any two Oracle database statspack snapshots from the same instance start-up time. You create statspack snapshots by using a tool such as SQL*Plus or SQL Developer. Also, Oracle provides a script called spauto.sql that you can modify and run to automate statspack snapshot gathering.

The Server Tools Oracle Statspack screen is available only if the database server is Oracle. For PolicyCenter to display statspack information, you must also:

Install the statspack package in your Oracle database (spcreate.sql).
Grant SELECT privileges on all the PERFTEST tables to the PolicyCenter database user.

If you do not install the statspack or fail to grant the correct permission, PolicyCenter displays an error message on the screen. You cannot select any snapshots on the screen either. Refer to the Oracle documentation for statspack installation instructions.

Guidewire recommendations

Guidewire recommends the following with regards to Oracle statspack snapshots:

Collect statspack snapshots at regular intervals if you do not have a license for Oracle AWR.
Collect the snapshots at level 7 or higher to collect execution plan and segment statistics.
Regularly purge statspack snapshots older than a certain period.

Guidewire recommends that you use the Guidewire AWR tool, rather than Oracle Statspack, if you have a license for the following:

Oracle Diagnostics package
Tuning package

If you do not have these licenses, Guidewire recommends that you acquire the two licenses.