Oracle statistics preferences

New in 9.0.5 is the ability of PolicyCenter to use the Oracle AutoTask infrastructure to manage the task of collecting table statistics. To enable this functionality, do the following:
  • Set the useoraclestatspreferences attribute to true on the <databasestatistics> element in file database-config.xml.
  • Enable Oracle AutoTask for statistics collection in the Oracle database.

Enabling this functionality makes visible an Oracle Statistics Preferences tab in the Server Tools Info > Database Statistics screen.

Resetting useoraclestatspreferences

Any change that you make to the value of useoraclestatspreferences (true to false or false to true) takes affect only after an upgrade, either a full upgrade or a rolling (configuration) upgrade. However, if you reset this attribute from true to false, PolicyCenter throws an exception during the next upgrade and prevents the upgrade from continuing due to locked table statistics in the Oracle database. Review the details of the exception provided in the server log to determine which table statistics need to be unlocked. See Revert to DBStats batch processing for database statistics for information on how to unlock the table statistics.

See also