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>