index clustering factor


exec dbms_stats.set_table_prefs(ownname=>user, tabname=>'BOWIE',pname=>'TABLE_CACHED_BLOCKS', pvalue=>42);

Bug 13262857  Enh: provide some control over DBMS_STATS index clustering factor computation

 This 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 affectedVersions BELOW 12.1
Versions confirmed as being affected
Platforms affectedGeneric (all / most platforms affected)


This issue is fixed in


Related To:


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.

Niciun comentariu:

Trimiteți un comentariu