stats_table

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

Syntax Syntax

stats_table = all|all_ind|missing|dbstatc_tab|dbstatc_mon|

dbstatc_mona|[<owner>.]<table>|[<owner>.]<index>|

[<owner>.][<prefix>]*[<suffix>]|<tablespace>|

(<object_list>)|info_cubes|all_part|harmful|locked|

```
system_stats|oradict_stats|oradict_tab
```


End of the code.


Default value: all objects of selected owners
Possible values
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.
oradict_tab: used to validate structure of Oracle dictionary objects. For more information, see SAP Note 863811.