1284406 - MISSING_STATISTICS warning after new installation

Symptom

Directly after a new installation of the SAP system, the BRCONNECT function "check" issues many warnings about missing index statistics, although new statistics were created by the BRCONNECT function "stats" during the installation.
For example:
...
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPSR3.ACC_INPH3_DPR~PKY
BR0970W Database administration alert - level: ERROR, type: MISSING_STATISTICS, object: (index) SAPSR3.ACC_INPH3_DYNPRO~P
...

Other Terms

BRCONNECT, missing statistics

Reason and Prerequisites

Oracle bug 6670551 in 10.2.0.2: "Indexes on empty tables don't have gathered statistics".
This bug is corrected in the Optimizer merge fix for Oracle 10.2.0.4 (see Note 1165319), but it still occurs after a new installation since the Oracle parameter required to activate the fix (_fix_control = '6670551:ON') cannot be set during the installation.
As of Release 10.2.0.5, the error is corrected generally (that is, the parameter _fix_control is no longer required for this).

Solution

Create the missing statistics directly after the installation using the following BRCONNECT call:
brconnect -u / -c -f stats -t missing
or using the standard call:
brconnect -u / -c -f stats -t all
This should take only a few minutes.

Header Data

Released On	23.08.2011 14:08:35
Release Status	Released for Customer
Component	BC-DB-ORA-DBA Database Administration with Oracle
Priority	Correction with low priority
Category	Installation information

Validity

Software Component From Rel. To Rel. And Subsequent SAP_BASIS 700 702 710 720

References

This document refers to:

SAP Notes

1165319		Optimizer merge fix for Oracle 10.2.0.4
1169802		OBSOLETE: Inst.NetWeaver 7.0 EHP1/BS 7 - UNIX/Oracle
1249365		OBSOLETE: Inst. SAP NW based on Kernel 7.11-Unix Oracle
830576		Parameter recommendations for Oracle 10g
946141		Inst. SAP Systems on UX/Oracle 10.2 with R3SETUP
969519		6.20/6.40 Patch Collection Installation : Oracle/UNIX
972263		OBSOLETE: Inst.NW 7.0(2004s)SR2/BS 2005 SR2-UNIX/Oracle
1094599		OBSOLETE: Inst.NW 7.0SR3/Business Suite 2005 SR3-UNIX/Oracle

This document is referenced by:

SAP Notes (4)

946141		Inst. SAP Systems on UX/Oracle 10.2 with R3SETUP
830576		Parameter recommendations for Oracle 10g
1165319		Optimizer merge fix for Oracle 10.2.0.4
969519		6.20/6.40 Patch Collection Installation : Oracle/UNIX