brconnect -u SYSTEM/xxxxxx -c -f stats -t all -p 4 ?

[pr_srinivas]

can any one explain above command about each switch user ?

If i want to collect statistics for all tables- will the subjected command will work ?

Rgds

[former_member204746 · Accepted solution]

type:

brconnect -h

you will get full explanation of each parameters.

as far as if it will do what your want, answer is yes.

[fidel_vales]

>

> can any one explain above command about each switch user ?
> 

Why don't you take a look at the documentation?

It is "freely" available on

-> http://help.sap.com

-> SAP on Oracle Homepage in SDN (there is a post with the address locked at the beginning of the forum, difficult to miss)

If you would bother you could have found the page with the [Command Options for BRCONNECT|http://help.sap.com/saphelp_nw70/helpdata/EN/11/53e43a744ebe14e10000000a11402f/content.htm]

>

> If i want to collect statistics for all tables- will the subjected command will work ?
> Rgds

Again, read the documentation to know exactly how it works.

The answer is no and yes.

Yes, the command it will work

No, the command will CHECK all the tables that need statistics based on an "algorithm" and then, if needed, it will calculate statistics for the tables.

You can find the algorithm on the documentation