Our system sits on Oracle DB. After performance testing I can see slow URL and can drill it down to the components.
How I can identify slow SQL statements, or SQL statements which consume most resources?
Thanks in advance.
You can refer to the Oracle AWR report, you need to take it during the test period.
the Oracle AWR report runs through Oracle, right? Do one ask DBA to analyze it or import results into LR?
Can we use any of LR stuff to drill down to SQL statement?
I think you will Diagnostics integrated with LR for method level drilldown.