How to check high Oracle SQL statement

As part of your job to make the SAP system performance always good, you actively monitor which SQL statement mostly having impact to the performance. Besides from ST04, you can also monitor the high SQL statement from SAP report as shown below:

Note: in this example the database is using Oracle.

  1. From SA38 run /SSF/RSORADLD_NEWsap-high-sql-statement-1
  2. Select the selection criteria and executesap-high-sql-statement-2
  3. You will see the summary of SQL statement since DB startupsap-high-sql-statement-3
  4. Double click one of the items to analyze furthersap-high-sql-statement-4

Leave a Reply