LoadRunner Practitioners Forum
cancel

Identifying slow SQL statements

Highlighted
jul_2
Super Contributor.

Identifying slow SQL statements

Hi Everyone

 

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.

3 REPLIES
Ajay_U
Honored Contributor.

Re: Identifying slow SQL statements

You can refer to the Oracle AWR report, you need to take it during the test period.

jul_2
Super Contributor.

Re: Identifying slow SQL statements

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?

 

Thanks

shiv_p
Acclaimed Contributor.

Re: Identifying slow SQL statements

I think you will Diagnostics integrated with LR for method level drilldown.