Skip to Content

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

brconnect question

Hello,

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|

dbstatc_mona|[<owner>.]<table>|[<owner>.]<index>|[<owner>.]<prefix>*|<tablespace>|<object_list>|info_cubes|locked|system_stats|oradict_stats

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

Rgds,

Youssef

Former Member
Former Member replied

Hello,

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