Update Statistics for InfoCube Tables (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Update Statistics for InfoCube Tables

Use

The InfoCube tables used in SAP Business Information Warehouse (SAP BW) and Advanced Planner and Optimizer (APO) need to be processed in a special way when the statistics are being updated. Usually, statistics should be created using histograms, as described in SAP Note 129252.

Statistics for the InfoCube tables can be updated, together with other tables in a run. In this case, the statistics for the InfoCube tables are always created with histograms. You specify which tables are to be handled as InfoCube tables using the init<DBSID>.sap parameter stats_info_cubes.

Prerequisites

The control table RSNSPACE for Business Information Warehouse (BW) and Advanced Planner and Optimizer (APO) dynamically determines which tables are to be handled as InfoCube tables. The content of the control table might change in future.

Features

Tables whose names start with the following prefixes are dealt with by BRCONNECT as InfoCube tables:

/BIC/F*, /BIC/A9F*,

/BI0/F*, /BI0/A9F*,

/BIC/E*, /BIC/A9E*,

/BI0/E*, /BI0/A9E*,

/BIC/D*, /BIC/A9D*,

/BI0/D*, /BI0/A9D*,

/BIC/S*, /BIC/A9S*,

/BI0/S*, /BI0/A9S*,

/BIC/X*, /BIC/A9X*,

/BI0/X*, /BI0/A9X*,

/BIC/Y*, /BIC/A9Y*,

/BI0/Y*, /BI0/A9Y*,

/BIC/I*, /BIC/A9I*,

/BI0/I*, /BI0/A9I*,

/BIC/P*, /BIC/A9P*,

/BI0/P*, /BI0/A9P*,

/BIC/Q*, /BIC/A9Q*,

/BI0/Q*, /BI0/A9Q*

The above list provides the default value of the init<DBSID>.sap parameter stats_info_cubes, that you can use to include the following kinds of tables in the list of InfoCube tables:

Groups with names starting with a certain prefix
Individual tables in the list of InfoCube tables

Caution

To include the above default list, specify the keyword DEFAULT in the first position, as in the following example:

stats_info_cubes = (DEFAULT, XYZ*)

To suppress special handling of the InfoCube tables completely, use the keyword NULL:

stats_info_cubes = NULL

If certain prefixes are omitted in the parameter definition, the corresponding tables are not to be handled as InfoCube tables. However, we do not recommend you to do this.

For additional, special handling of InfoCube tables, you can use the keyword INFO_CUBES for the following:

BRCONNECT with the -f stats function using the -t|-table and -e|-exclude options

init<DBSID>.sap parameters:

stats_table

stats_exclude

stats_dbms_stats

The function of this keyword is to ensure that only InfoCube tables are processed in accordance with the selected parameter settings.

Examples

brconnect -u / -c -f stats -t info_cubes

Statistics are only checked for InfoCube tables and updated, if required

brconnect -u / -c -f stats -t all -e info_cubes

Statistics are checked for all tables besides InfoCube tables and updated, if necessary.

stats_dbms_stats = INFO_CUBES:R:4
brconnect -u / -c -f stats -t all

Statistics are checked for all tables and updated, if necessary. New statistics for InfoCube tables are created with the DBMS_STATS package using row sampling and an internal parallel degree of 4.

For more information, see stats_dbms_stats.

brconnect -u / -c -f all

This is the default. Statistics are checked for all tables and updated, if necessary. If InfoCube tables are present and selected following the update check, statistics are generated for them using histograms.

Note

In the current SAP standard system, all InfoCube tables are entered in control table DBSTATC with active flag "I" (ignore). This means that InfoCube tables from BRCONNECT are ignored and not processed at all. Before you can process them, the corresponding DBSTATC entries must be changed or deleted.

Alternatively, you can use option -f allsel to force processing of InfoCube tables, for example:

brconnect -u / -c -f stats -t info_cubes -f allsel