Skip to Content

Recurent Harmful statistics in our Solman 7.2

Good afternoon,

In our Solman 7.2, we have, everyday, db13 / dbcheck warnings concerning HARMFUL_STATISTICS for thousands of tables.

It is mostly for SMO* tables.


If I delete the harmful stats, the warning would come back again the day after because the table exists and Oracle automatically creates its' stats.

Have you faced a similar behavior?

Would you now what should be done to avoid this behavior?

I provide the list of tables impacted in this file: missingstats.txt

Thanks in advance for your help.

missingstats.txt (301.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 06, 2018 at 10:34 AM

    Hi Benoit

    Haven't seen this but found an old thread which points to interesting information:

    https://archive.sap.com/discussions/thread/2148302

    Best regards

    Tom

    Add comment
    10|10000 characters needed characters exceeded