Granularity ‘APPROX_GLOBAL AND PARTITION’

Published 03 Oktober 08 10:27 | Striving for Optimal Performance
The patchset 11.1.0.7 introduces in the package DBMS_STATS a new value for the parameter GRANULARITY. The description provided by the development team in $ORACLE_HOME/rdbms/admin/dbmsstat.sql is the following: 'APPROX_GLOBAL AND PARTITION' - This option is similar to 'GLOBAL AND PARTITION'. But the global statistics are aggregated from partition level statistics. It will aggregate [...]

Lesen Sie den vollständigen Eintrag unter http://antognini.ch/2008/10/granularity-approx_global-and-partition/

Abgelegt unter: ,