Solution : https://service.sap.com/sap/support/notes/1601951 (SAP Service marketplace login required)
Summary :
SAP Note details the Self Service "SQL Statement Tuning" for optimization of ABAP systems running on Oracle or DB2 UDB platforms. It explains the conditions under which the tuning should be performed, including significant database contributions to system load and general performance issues flagged by EarlyWatch Alert reports. The note describes the steps of preparation, analysis using collected data, and follow-up actions through the Solution Manager. Specific procedural details vary depending on the Solution Manager's version, highlighting the use of tools like "solman_workcenter" for session management and task assignment for identified SQL issues.
Key words :
content edition st-ser 701_2008_2, abap based systems running oracle, content edition st-ser 701_2010_1, st-ser 2001_2010_1 support package 2, abap based systems running, st-pi 2008_1_[46c-710], abap based sap systems, expert guided implementation session, st-ser 2010_1 sp 10, database time contributes significantly
Related Notes :
| 1625795 | DB2 UDB (LUW) SQL check rating strategy for EarlyWatch Alert |
| 1609155 | Guided Self Services |
| 1572183 | Authorizations for SAP Solution Manager RFC users |
| 1564508 | /SDF/RSORADLD_NEW: No statements during autom. download |
| 1550309 | SD: Create questionnaire not enabled for guided self service |
| 1517658 | SD: Incorrect error message while opening self service |
| 1405975 | Minimum Authorization Profile for Remote Service Delivery |
| 1317901 | Service content update |
| 1267189 | DBA Cockpit: DB2 for LUW as Remote Database |
| 1257308 | FAQ: Using EarlyWatch Alert |
| 1143775 | SAP Service Content Update |
| 903528 | Solution Manager issue management and service plan: BC sets |
| 872800 | Roles for SAP Solution Manager: SAP service provider |
| 766349 | FAQ: Oracle SQL optimization |
| 763561 | Service Data Control Center (SDCCN) - FAQ |
| 569116 | Release strategy for Solution Manager Service Tools (ST-SER) |
| 551646 | Oracle SQL check rating strategy for EarlyWatch Alert |