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:
|
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. |
