Bug 13262857 Enh: provide some control over DBMS_STATS index clustering factor computationThis note gives a brief overview of bug 13262857.
The content was last updated on: 08-MAR-2013
Click here for details of each of the sections below.
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected)
This issue is fixed in
This is an enhancement to allow a user to specify the number of blocks that DBMS_STATS package will consider when gathering the index clustering factor statistics. Prior to this enhancement (also the default with this enhancement) DBMS_STATS assumed 1. With this enhancement a user will be able to specify a value between 1 and 255. There is also an AUTO option which if specified then dbms_stats will use 1% of the table blocks up to 0.1% of the buffer cache size (in blocks). Rediscovery Notes: none - this is an enhancement not a bug. Workaround None