debugging plsql/sql statements
Hi Team,
We generated an ASH report attached
for a performance issue and identified two PL/SQL blocks/packages. However, we are unable to determine the actual SQL statements being executed by these PL/SQL calls, as no corresponding SQL is clearly visible in the report.
We have two questions:
- For an already captured ASH report:
If ASH shows only PL/SQL entry points (package/procedure) and not the underlying SQL statements, how can we identify the SQL executed by those PL/SQL routines?
Are there any views or methods (ASH/AWR/SQL Monitor/Trace) that can help correlate the PL/SQL execution with the SQL IDs?
Tagged:
0