The Oracle Outlines screen

The Server Tools Oracle Outlines screen is only available if the database server is Oracle. The screen contains information on any Oracle outlines defined in the PolicyCenter Oracle database. Oracle defines an outline as a collection of hints associated with a specific SQL statement, used to provide SQL execution plan stability. Consult the Oracle documentation on how to write and use Oracle Outlines.

The Oracle Outlines summary table contains the following information:

Name

Name of the Oracle outline. Click to open the Outline Details screen. This screen contains the SQL hints used to define the outline.

Category

Optional name used to group stored outlines.

Used

Whether the Oracle database has ever used this particular outline.

Time Stamp

Date and time of the last use of this outline.

Version

Oracle database version.

SQL

SQL query text that creates the database outline.

Signature

Unique identifier for this outline.

Compatible

Whether the stored outline is compatible with this database version.

Enabled

Whether Oracle enables this outline in the database.
Note: Oracle AWR contains a column that indicates if PolicyCenter used an Oracle Outline for a given SQL statement.

See also

View an Oracle Outlines report

About this task

The Server tools Oracle Outlines screen contains information on any Oracle Outlines defined in the Oracle database.

Procedure

  1. Log into Guidewire PolicyCenter using an administrative command.
  2. Navigate to the Server Tools Info Pages > Oracle Outlines screen.
  3. Click Download.
  4. In the download dialog, set the download location.
  5. Click OK to download and save the report.
  6. Open the downloaded ZIP file and click Outlines.html to open the report.

What to do next

See also