Show TOC

Syntax documentationstats_table Locate this document in the navigation structure

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 Syntax

  1. stats_table = all|all_ind|missing|dbstatc_tab|dbstatc_mon|
  2. dbstatc_mona|[<owner>.]<table>|[<owner>.]<index>|
  3. [<owner>.][<prefix>]*[<suffix>]|<tablespace>|
  4. (<object_list>)|info_cubes|all_part|harmful|locked|
  5. system_stats|oradict_stats|oradict_tab
    7. 



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: validates structure
for Oracle dictionary objects. For more information, see SAP Note 863811.