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.