stats_dbms_stats (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

stats_dbms_stats

This parameter defines how the DBMS_STATS package is used to update statistics with BRCONNECT.

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

If X = R: activates row sampling

If X = B: activates block sampling

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

info_cubes: only processes InfoCube tables with DBMS_STATS package

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).

Example

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 = (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

For more information on DBMS_STATS, see Update Statistics