Solution : https://service.sap.com/sap/support/notes/558197 (SAP Service marketplace login required)
Summary :
Issues during the upgrade phases such as PARCONV_UPG, SHADOW_IMPORT_UPG2, XPRAS_UPG, and JOB_RSINDCHK when using Oracle databases version below 10g are observed due to high CPU usage by Oracle processes. This often involves database sessions locked on select statements dealing with 'user_ind_columns' or 'dba_ind_columns'. The solution includes downloading and running specific scripts from the SAP service portal to optimize database views, reducing dictionary statistics issues and streamlining the upgrade process. Post-upgrade, different steps are recommended for R3 and BW systems to revert view definitions.
Key words :
sql> connect sapr3/<password>sql> drop synonym user_ind_columns, goto st04 -> detail analysis menu -> oracle sessions 4, terms user_ind_columnsdba_ind_columns100% cpuparconv_upgshadow_import_upg2job_rsindchkxpras_upgno upgrade activity reason, goto transaction sm50, sql sql>select, directory oracle -> oracle, oracle data dictionary, 3rdparty maintenance softwarecenter, oracle database version, oracle shadow process
Related Notes :
| 900345 | Backward Release of ORACLE 10.2 - Upgrade Information |
| 871455 | Poor performance when accessing DBA and V$ views |
| 662219 | Add. info. on upgrading to SAP Web AS 6.40 ORACLE |
| 575280 | Add info about upgrade to SAP Web AS 6.20 ORACLE 9.2.0 |
| 558746 | Better Oracle Data Dictionary BW Performance |
| 519448 | Performance problems when deactivating aggregates |
| 401721 | on upgrading to SAPWeb AS 6.10 ORACLE |
| 354080 | Note collection for Oracle performance problems |
| 303461 | Additions to Upgrade to Basis 4.6D Oracle |
| 201874 | Additions for upgrade to 4.6C/4.6C SR1/4.6C SR2 Oracle |