Skip to Content
author's profile photo Former Member
Former Member

missing statistics

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Feb 22, 2008 at 10:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Apr 02, 2008 at 06:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 02, 2008 at 08:47 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.