The Oracle Statistics Preferences tab

The Oracle Statistics Preferences tab presents information about the table statistics preferences set for the Oracle database. To view this information, navigate to the following location in Guidewire PolicyCenter:
  • Server Tools Info Pages > Database Statistics screen, Oracle Statistics Preferences tab
To be able to view the Oracle Statistics Preferences tab:
  • The database is Oracle.
  • Attribute useoraclestatspreferences on the databasestatistics element in file database-config.xml is set to true.
Note: You must perform an upgrade (either full or rolling) after setting attribute useoraclestatspreferences to true in order for the change to the useoraclestatspreferences attribute to become effective.

Actual and configured table preferences

To configure database statistics in BillingCenter, one sets statistics options in file database-configl.xml, either at the global database level, or, at the individual table level. To be clear, you set statistics options in database-configl.xml, which BillingCenter then uses to set the actual table statistics preferences during the upgrade.

It is also possible to set table statistics preferences directly in the Oracle database by executing the following command:
  • DBMS_STATS.SET_TABLE_PREFS

If you set table statistics preferences directly, the actual table statistic preferences no longer match the configured table statistics preferences. During a database upgrade, BillingCenter ignores any actual table statistics preferences and sets table statistics preferences to those defined in the new database-config.xml file. The information provided on the Oracle Statistics Preferences tab provides a mechanism to capture direct changes made to the table statistics preferences that are lost during a database upgrade

Button actions

The following list describes the actions of the individual button in the Oracle Statistics Preferences tab.
Button Action
Refresh Refreshes the table information on the screen.
Download Downloads the database-config table statistics options as a JSON file.
Reapply Config Reapplies the table statistics options configured in file database-config.xml to the database, discarding any preferences set outside the application. As you initiate this process, BillingCenter inserts an entry into the application log and then inserts another entry at the end of the process.
Generate Config to Match Actual Generates an XML file that details the table statistics preferences actually in use in the database.
Dev Mode only (Drop-down) Selects that environment in which to generate the table statistics.

You can also filter the list of tables using the drop-down at the right of the tab.