Solution : https://service.sap.com/sap/support/notes/382329 (SAP Service marketplace login required)
Summary :
Performance issues and frequent terminations with ORA-01555 errors are reported for long-running data extractions using CO delta DataSources like 0CO_OM_CCA_9 due to suboptimal execution of SQL statements on COVP table. The problem is linked to inactive indexes 1 or 4 for the COEP table and improper use of |OR|-joined conditions during SQL execution. Solutions include verifying the activation of SAP-delivered indexes for COEP, ensuring customer-defined indexes do not impact performance, and refreshing statistics for the Oracle Cost-Based Optimizer. Corrective notes and program adjustments are necessary if previous patches have been implemented. Alternative transaction settings for selecting data are suggested to minimize conditions linked by OR.
Key words :
oracle cost-based optimizers, sql trace tells, ora-01555 short dumps, oltpsource = ' 'param_name = 'objselsize', bw-bct-coom, prerequisites database index 1, performance problems caused, database system optimizer, extraction frequently terminates, tolerate select-statements
Related Notes :
| 836740 | Delta extractors CO: OBJSELSIZE DataSource specific |
| 578417 | BCT-CO: CO-OM delta DataSources: Executing the DeltaInit |
| 410130 | PSBW: Extraction of costs: Performance problems |
| 408215 | BCT-CO totals record DataSourcen for costs |
| 399123 | CO delta extractors: Error in Note 387964 |
| 398041 | INFO: CO-OM/IM-Content (BW) |
| 397286 | CO-delta-extractors: SQL error in the delta mode |
| 387964 | CO delta extractors: poor performance for Deltainit |
| 374228 | CO delta extraction: Docs twice with ALE |