problems with missing statistics in checkdb - oracle

[Former Member]

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!!

[Former Member]

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

[Former Member]

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