Show TOC

stats_tableLocate this document in the navigation structure

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.

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

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 Information published on SAP site.

  • oradict_tab: used to validate structure of Oracle dictionary objects. For more information, see SAP Note 863811 Information published on SAP site.