stats_table

This parameter defines the database objects to be processed by the  BRCONNECT update statistics function. You can use this parameter to restrict update statistics to selected objects.

Syntax:

stats_table = all|all_ind|missing|dbstatc_tab|dbstatc_mon|
dbstatc_mona|[<owner>.]<table>|[<owner>.]<index>|[<owner>.]<prefix>*|
<tablespace>|(<object_list>)|info_cubes|all_part|harmful|locked|
system_stats|oradict_stats

Default: All objects of selected owners

·        all: All SAP tables and indexes

·        all_ind: All indexes only. For example, you can use this to create space statistics for all indexes.

·        missing: Only tables and indexes with missing statistics

·        dbstatc_tab: Only tables specified in the DBSTATC control table

·        dbstatc_mon: Only tables specified in the DBSTATC control table that are relevant for the application monitor

·        dbstatc_mona: Only application tables specified in the DBSTATC control table that are relevant for the application monitor

·        info_cubes: Only InfoCube tables

·        all_part: Only partitioned tables

·        harmful: Used in connection with option –d to delete damaging statistics

·        locked: All tables with locked statistics

·        system_stats: Collects system (CPU, I/O) statistics using the DBMS_STATS package. For more information, see SAP Note 601395.

·        oradict_stats: Collects statistics for Oracle dictionary objects using DBMS_STATS package. For more information, see SAP Note 863811.