Get Open SQL from Native SQL (SAP on Oracle)
This is normally helping us to check single SQL performance from application perspective. By doing this we can search the “Open SQL” from SAP note/kba, then we will see whether this is known issue from application point of view, most of time, application already add database hint on this particular Open SQL.
There are two ways to get Open SQL:
1. for running session
ST04->Performance->Wait Event Analysis->Wait Event Analysis->highlight the session you are interested, then hit “ABAP Source” button, it will show the Open SQL.
2. for past session, but we need to SQL_ID
ST04->Performance->SQL Statement Analysis->Shared Cursor Cache->input the SQL_ID->highlight the session you are interested, then hit “ABAP Source” button, it will show the Open SQL.
Both of the steps are like this: