Oracle database options

To filter the information in the Server Tools Database Storage Information screen, select one of the following options from the Storage Set to Display drop-down filter:

Storage Set to Display              

Description                                                                                                                         

Guidewire Version

Guidewire product-specific information such as application and platform version.

Indexes Alloc Space

Space allocation of each index on a table, in megabytes.

Oracle LOBs Alloc Space

Space allocation information for Large Object Blocks (LOBs), sorted by LOB name.

Oracle User LOBs

Space allocation information similar to that shown for Oracle LOBs Alloc Space, sorted by table name.

Queries Executed to Build Download

List of SQL queries used to generate the data. The data includes the SQL used to generate the query and other information such as the number of rows returned the time it took for the query to run.

Summary of Queries Executed to Build Download

Simple summary of the number of queries involved in generating the data and the total database time that the queries took to execute.

Table Alloc Space + Estimated Advanced Compression Settings

Size in megabytes for each table in the database.

The information that you see depends on the filter options that you set:

  • If you select the Include Estimation of Compression Savings for Tables and Indexes option, PolicyCenter modifies the storage set name to indicate that fact and provides the requested information.
  • If you do not select the Include Estimation of Compression Savings for Tables and Indexes option, you see only Table Alloc Space as the storage set name. PolicyCenter does not show compression estimation savings information.

Tablespace Space

Size of each tablespace in megabytes, along with information on how much of the space is in use or is free space.

Tablespaces

List of each tablespace in the database along with related information.

User Indexes

Information on each user index in the database, selectable by index name.

User Tables

Information on each user table in the database, selectable by table name.