Solution : https://service.sap.com/sap/support/notes/93098 (SAP Service marketplace login required)
Key words :
sapdba command line options optimizer control panel, generation update phasein phase ii statistics, 0a solution oracle database optimizer1, command line optionsdemand check phase, >sapdba -checkopt psap%phase ii, control table dbstatccontrol table dbstatc, individual methods/options entered, analyze index estimate/compute statistics, update dbstatc set/remove, 000e_p30 - estimate 30 percent range
Related Notes :
| 391863 | Performance problems for TO list display |
| 173993 | Cluster: System settings during Euro LC changeover |
| 132861 | CBO: Statistics creation with SAPDBA or BRCONNECT |
| 131372 | CBO: Tuning of expensive SQL statements |
| 106047 | DB21: Customizing the DBSTATC |
| 102590 | CBO: DBSTATC during upgrade or new installation |
| 93292 | Additional Info: Upgrading to 4.0A ORACLE |