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 ...)