-force with Update Statistics (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

-force with Update Statistics

This section gives examples of how you can use the -force options to override the internal rules for update statistics. For more information about the -force options, see -f stats.

This graphic is explained in the accompanying text

Only use these options in exceptional circumstances.

Check and update statistics for all tables in tablespace PSAPBTAD, including pool and cluster tables

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

Update statistics without check for all tables relevant to the application monitor

brconnect -u / -c -f stats -t dbstatc_mon -f collect

Update statistics for a pool table specified in the DBSTATC table, to determine space usage, using method "estimate 10% rows"

brconnect -u / -c -f stats -t atab -m EI -s P10 -f allsel,method,sample

BRCONNECT stores the space usage data in tables DBSTATTORA (for tables) and DBSTATIORA (for indexes). Finally, the statistics are immediately deleted.

If you want to keep the statistics – for example, for test purposes – you must include the keep option in the command, as follows:

brconnect -u / -c -f stats -t rfblg -m EI -s P10 -f allsel,method,sample,keep

Check and update statistics according to the two-phase concept:

First phase: Check statistics

brconnect -u / -c -f stats -t all -f nocoll

Second phase: Update statistics on tables identified in the first phase

brconnect -u / -c -f stats -t all -f nocheck