help,why brconnect do not collect statistics for mseg table?

[Former Member]

I found "MSEG" table`s statistics is too old.

so i check logs in db13,and the schedule job do not collect statistics for "MSEG".

Then i execute manually: brconnect -c -u system/system -f stats -t mseg -p 4

this command still do not collect for mseg.

KS1DSDB1:oraprd 2> brconnect -c -u system/system -f stats -t mseg u2013f collect -p 4

BR0801I BRCONNECT 7.00 (46)

BR0154E Unexpected option value 'u2013f' found at position 8

BR0154E Unexpected option value 'collect' found at position 9

BR0806I End of BRCONNECT processing: ceenwjre.log 2010-11-12 08.41.38

BR0280I BRCONNECT time stamp: 2010-11-12 08.41.38

BR0804I BRCONNECT terminated with errors

KS1DSDB1:oraprd 3> brconnect -c -u system/system -f stats -t mseg -p 4

BR0801I BRCONNECT 7.00 (46)

BR0805I Start of BRCONNECT processing: ceenwjse.sta 2010-11-12 08.42.04

BR0484I BRCONNECT log file: /oracle/PRD/sapcheck/ceenwjse.sta

BR0280I BRCONNECT time stamp: 2010-11-12 08.42.11

BR0813I Schema owners found in database PRD: SAPPRD*, SAPPRDSHD+

BR0280I BRCONNECT time stamp: 2010-11-12 08.42.12

BR0807I Name of database instance: PRD

BR0808I BRCONNECT action ID: ceenwjse

BR0809I BRCONNECT function ID: sta

BR0810I BRCONNECT function: stats

BR0812I Database objects for processing: MSEG

BR0851I Number of tables with missing statistics: 0

BR0852I Number of tables to delete statistics: 0

BR0854I Number of tables to collect statistics without checking: 0

BR0855I Number of indexes with missing statistics: 0

BR0856I Number of indexes to delete statistics: 0

BR0857I Number of indexes to collect statistics: 0

BR0853I Number of tables to check (and collect if needed) statistics: 1

Owner SAPPRD: 1

MSEG

BR0846I Number of threads that will be started in parallel to the main thread: 4

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2010-11-12 08.42.16

BR0817I Number of monitored/modified tables in schema of owner SAPPRD: 1/1

BR0280I BRCONNECT time stamp: 2010-11-12 08.42.16

BR0877I Checking and collecting table and index statistics...

BR0280I BRCONNECT time stamp: 2010-11-12 08.42.16

BR0879I Statistics checked for 1 table

BR0878I Number of tables selected to collect statistics after check: 0

BR0880I Statistics collected for 0/0 tables/indexes

BR0806I End of BRCONNECT processing: ceenwjse.sta 2010-11-12 08.42.16

BR0280I BRCONNECT time stamp: 2010-11-12 08.42.17

BR0802I BRCONNECT completed successfully

the log says:

Number of tables selected to collect statistics after check: 0

Could you give some advices? thanks a lot.

[Former Member · Accepted solution]

Hello,

If you would like to force the creation of that stats for table MSEG you need to use the -f (force) switch.

If you leave out the -f switch the parameter from stats_change_threshold is taken like you said correctly:

[http://help.sap.com/saphelp_nw70ehp1/helpdata/EN/02/0ae0c6395911d5992200508b6b8b11/content.htm|http://help.sap.com/saphelp_nw70ehp1/helpdata/EN/02/0ae0c6395911d5992200508b6b8b11/content.htm]

[http://help.sap.com/saphelp_nw70ehp1/helpdata/EN/cb/f1e33a5bd8e934e10000000a114084/content.htm|http://help.sap.com/saphelp_nw70ehp1/helpdata/EN/cb/f1e33a5bd8e934e10000000a114084/content.htm]

You have tried to do this in your second example :

==> brconnect -c -u system/system -f stats -t mseg u2013f collect -p 4

Therefore you received:

BR0154E Unexpected option value 'u2013f' found at position 8

BR0154E Unexpected option value 'collect' found at position 9

This is the correct statement, however the hyphen in front of the f switch is not correct.

Try again with the following statement (-f in stead of u2013f) you will see that it will work:

==> brconnect -c -u system/system -f stats -t mseg -f collect -p 4

I hope this can help you.

Regards.

Wim

[Former Member]

Is it because stats_change_threshold=50.

Then is it necessary to collect statistics for mseg table everyday?

and which value do you set for stats_change_threshold?

Edited by: victor on Nov 12, 2010 1:59 AM