Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

brconnect question


I would like to compute statistics for some specific tables in Oracle. For example I would like to compute statistics for all tables that start with A.

If I have understood the documentation, we should use the option:

-t|-table: Defines the objects to be processed by update statistics.

Input syntax: -t|-table all|all_ind|all_part|missing|harmful|dbstatc_tab|dbstatc_mon|


So I have tried the following command:

brconnect -u / -c -f stats -t A* -m C

But it doesn't seem to work. If this doesn't work, is there an option for brconnect that allows us to not log the output in SAP (DB24, DB14, etc ...)





I think the following note answer your question:

865365 Placeholder support in BRCONNECT parameters

you should use:

brconnect -u / -f stats -t <b>"A*"</b> -m C

Note that if you want to <b>force</b> the stats to be calculated ( no threshold check ) then you have to add the option -f collect:

brconnect -u / -f stats -t "A*" -m C <b>-f collect</b>

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question