To provide a standard framework to gather Oracle cost based optimizer (CBO) statistics, a standard pl/sql package 'wgn_stats' has been developed and is now shipped with CA DataMinder.
The package is automatically installed in the CA DataMinder schema, and is available for a DBA to call as part of the normal operational procedures for maintaining the database, along with other activities such as partition maintenance, purging backups and so on.
This standard package removes some of the burden from DBAs of having to design and set up a statistics gathering process for CA DataMinder. It also allows CA to improve customer support by having a single point of reference when discovering how a customer is gathering CBO statistics.
Our experience has shown that different customers have different volumes and patterns of data, and even a single customer's data volume changes over time. The package is therefore flexible enough to allow these differences to be accommodated, while at the same time providing ease of use for simple installations.
Note: The statistics gathered by this package are specific to CA DataMinder and do not replace the gathering of system statistics (that is, Workload Statistics for system performance) or the Oracle Data Dictionary statistics.
|
Copyright © 2014 CA.
All rights reserved.
|
|