Skip to Content
avatar image
Former Member

problems with missing statistics in checkdb - oracle

Hi!

I've a problem of missing statistics (chekdb) in db13 transaction

our system properties:

DB -> ORACLE 10.2.0.2.0 - BRCONNECT 7.00 (18)

OS -> SunOS 5.10

SAP ERP Central Component 5.0

SAP Version 640

In a normal situation I put the tables/indexes in DBSTATC in db21 transaction and activating the verification & update checkboxes as well

I've done it, after that I've launched update statistics & checkdb in db13, everything was ok, but the next day checkdb has the same error with the same tables/indexes

Should I upgrade to the lastest patch level of brtools? any idea to solve this problem?

Thanks in advance!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 17, 2007 at 10:00 AM

    Yes try upgrading it to the latest patch level,in some cases Statistics Updates terminates on big tables.

    Do the upgrade then we will see it from there

    Regards,

    Cherry

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13, 2007 at 09:59 AM

    HI,

    DID U REBUILD THE INDEX OF THE TABLES WHICH WERE REPORTED TO HAVE MISSING INDEXES?

    FO THIS

    RUN BRTOOLS=====>3(SEGMENT MANAGEMENT)=====>2(REBUILD INDEX)

    SPECIFY THE INDEX NO IT WILL BE LIKE ~XXXX

    HOPE THIS HELPS

    REGARDS

    Add comment
    10|10000 characters needed characters exceeded