Oradbcheck error-Missing statistics appear again and again on the same Table(s)

ORADBCHECK ERROR:

Missing statistics appear again and again on the same table(s)

Issue:

Even after the BRTOOLS upgrade as recommended by SAP via message 1024584 these missing stats on certain tables keep appearing.

For example:

In FDE, following tables were observed with missing stats

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table - column_stats) SAPSR3./BIC/FZZXXSP1

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table - table_stats) SAPSR3./BIC/B0002794000

BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table - table_stats) SAPSR3./BIC/SZZREF_HT

Solution:

This happens because of the stats on these tables are locked on the DB level and they need to be unlocked.

Follow commands below: for table SAPSR3./BIC/FZZXXSP1

To unlocks stats:

SQL> exec dbms_stats.unlock_table_stats('SAPSR3','"/BIC/FZZXXSP1"');

Collect the statistics on this table again with forced mode:

brconnect -p initFDE.sap -u / -f stats -t SAPSR3./BIC/FZZXXSP1 -p 1 -force collect

Check DB again:

brconnect -u / -c -f check

The warning should disappear.