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 ...)
Fidel Vales replied
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>