cancel
Showing results for 
Search instead for 
Did you mean: 

missing statistics

Former Member
0 Kudos

Hi,

BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.MC03BF0SETUP

BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.MC03BX0SETUP

BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (table) SAPR3.MC03UM0SETUP

BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.MC03BF0SETUP~0

BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.MC03BX0SETUP~0

BR970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPR3.MC03UM0SETUP~0

even after i created stats for these tables, in next checkdb run stat's are missing....

can anybody give me solution pls?

Thanks in adv.

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member185954
Active Contributor
0 Kudos

Hello,

I normally run the RSANAORA report.

Assuming you have ORACLE database, what you can do is start the report in SE38 transaction.

Provide the list of objects tables/index and use the compute function in the selection screens to compute statistics for the same.

You can run the report in background.

Note that you can also rebuild indexes online using this report.

Also, you may wish to rebuild indexes using DB02 , it internally runs the same report.

I wrote a blog on [Rebuilding indexes online using DB02|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/8734] [original link is broken] [original link is broken] [original link is broken];

Regards,

Siddhesh

Former Member
0 Kudos

Hi,

SAP always advices to carry out such activitithe BRTOOLS.

Run BRTOOLS--


>Select SEGMENT MGT(3)---->select REBUILD INDEX(2).

Here Provide the TblSpace name or the Table Name or the Index name as the case may be.

In yr case the tble names are

MC03BF0SETUP

MC03BX0SETUP and table index are

MC03BF0SETUP~0

SAPR3.MC03BX0SETUP~0

SAPR3.MC03UM0SETUP~0

input these parameters and continue as per the guided procedure.

Hope this helps.

Pl award suitably if resolved.

Regards

stefan_koehler
Active Contributor
0 Kudos

Hello,

>> can anybody give me solution pls?

Please check, if the objects are recreated.

> shell> sqlplus "/ as sysdba"

> SQL> select OBJECT_NAME, OBJECT_ID, DATA_OBJECT_ID, CREATED, LAST_DDL_TIME from ALL_OBJECTS where OBJECT_NAME like 'MC03BF0SETUP%' or OBJECT_NAME like 'MC03BX0SETUP%' or OBJECT_NAME like 'MC03UM0SETUP%';

Regards

Stefan

Former Member
0 Kudos

Hi stefan,

Daily dbcheck giving warnings for missing stats in prod...

Last objects recreated on 31st Mar, 2008 ..

eventhough warnings are there...

if i create in db20 also it's not effecting...

Any other solution to resolve this?

Thank you