Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!

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