MISSING_STATISTICS

[Former Member]

Hi Gurus,

While running the batabase check(DB13), we are getting errors like

'BR0970W Database administration alert - level: ERROR, type:

MISSING_STATISTICS, object: (table) SAPSR3.XXXXX'.

Please help us to sort out this issue.

ECC6.0+Oracle

Kernal Patch: 83.

Regards,

Sreejesh

[Former Member]

Hi Sreejesh,

Please check whether you have shceduled the updated statistics job in DB13.

If not schedule it once a week.

Please confirm the message once it is solved.

Cheers.

-

---

Shamish

[zdenko_rohac]

If you have update statistics job scheduled, there is still possibility that developers created some new db objects which misses the actual stats. You can build statistics for such objects by running command:

brconnect -u / -c -f stats -t missing

Regards

Zdenko Rohac.

[Former Member]

Hello,

you should collect statistics at least one or two times a week. It is possible to create them through the transactions DB13 or DB20 or on tte OS Level with brconnect (it is better to automate it with a crontab job).

Best regards

K. Baran

[Former Member]

Hi,

The note 435290 has a description of this warning condition:

<i> 21. MISSING_STATISTICS (formerly NO_OPT_STATS)

This condition checks to see whether there are tables or indices that do not have any statistics, although they should have them.

The OBJECT field is not specified for this condition.

This condition has no checking operands, threshold values and value

units.</i>

You should calculate statistics for the mentioned table and/or investigate the reason it does not have statistics.