stats_dbms_stats

This parameter defines how the DBMS_STATS package is used to update statistics with BRCONNECT. DBMS_STATS is the default method used in Oracle 10g.

Syntax: stats_dbms_stats = [ALL:<X>:<degree>|[<owner>.]<table>:
<X>:<degree>|[<owner>.]<prefix>*:<X>:<degree>|<entry list>|info_cubes:<X>:<degree>|all_part:<X>:
<degree>|NO

If X = R: activates row sampling

If X = B: activates block sampling

<degree>: degree of parallelism for the collection of statistics:

·        0 means table default degree

·        1 means DBMS_STATS auto-degree

info_cubes: only processes InfoCube tables with DBMS_STATS package

all_part: only processes SAP partitioned tables

The optional entry ALL:R|B:<degree>activates the DBMS_STATS package for all selected tables and defines the standard sampling type and degree of parallelism. Without this entry, only the specified tables are processed.

The sampling type and degree of parallelism that you enter for the specified tables overrides the default sampling type and degree of parallelism (as defined for a table in Oracle dictionary).

NO: ANALYZE statement is used to update statistics. This is the default method in Oracle 9i.

·         stats_dbms_stats = ALL:R:1

This parameter activates the DBMS_STATS package with row sampling for all selected tables, without parallelism.

·         stats_dbms_stats = (ALL:R:2, ATAB:B:3, RFBLG:B:4)

This parameter activates the DBMS_STATS package for:

·         ATAB table, with block sampling and parallelism degree 3

·         RFBLG table with block sampling and parallelism degree 4

·         All other selected tables with row sampling and parallelism degree 2

·         stats_dbms_stats = (NO, ATAB:R:3, RFBLG:R:4)

This parameter activates the DBMS_STATS package for:

·         ATAB table, with row sampling and parallelism degree 3

·         RFBLG table with row sampling and parallelism degree 4

All other selected tables are processed with the ANALYZE statement (not recommended in Oracle 10g).

For more information on DBMS_STATS, see Update Statistics