Database statistics generation

Batch processing type Database Statistics (DBStats) generates the data available on Database Catalog Statistics Information screen.

Development mode

In development mode, it is possible to run the Database Statistics proess in any of the following ways:

From a command prompt, using the -updatestatistics option of the system_tools command
From the Execution History tab of the Server Tools Database Statistics screen
As a scheduled batch process

Production mode

In production mode, it is possible to run Database Statistics process in the following ways only:

From a command prompt, using the -updatestatistics option of the system_tools command.
As a scheduled batch process

Oracle AutoTask

For Oracle databases, it is possible to use the Oracle Autotask infrastructure to manage the collection of database table statistics. To use Oracle AutoTask, do the following:

Disable any scheduled runs of DBStats batch processing.
Set attribute useoraclestatspreferences attribute on the <databasestatistics> element in file database-config.xml to true.

You must use either Oracle AutoTask or DBStats batch processing to manage the collection of database statistics. Do not attempt to use both methods simultaneously.