Re: Identifying slow SQL statements (253 Views)
Reply
Regular Advisor
jul_2
Posts: 156
Registered: ‎05-02-2008
Message 1 of 4 (290 Views)

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.

Please use plain text.
Valued Contributor
Ajay_U
Posts: 108
Registered: ‎04-30-2012
Message 2 of 4 (283 Views)

Re: Identifying slow SQL statements

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

Please use plain text.
Regular Advisor
jul_2
Posts: 156
Registered: ‎05-02-2008
Message 3 of 4 (278 Views)

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

Please use plain text.
Honored Contributor
shiv_p
Posts: 2,841
Registered: ‎04-23-2008
Message 4 of 4 (253 Views)

Re: Identifying slow SQL statements

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

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation