How are expensive SQL select statements recognized?

Question Posted / inder09

Answers were Sorted based on User's Feedback

How are expensive SQL select statements recognized?..

Answer / inder09

High database request time caused by many buffer requests on
the database

High database request time as part of the response time

Is This Answer Correct ?

6 Yes

0 No

How are expensive SQL select statements recognized?..

Answer / mohit singhal

using Tx: ST05 - Performance analysis

Is This Answer Correct ?

1 Yes

0 No

How are expensive SQL select statements recognized?..

Answer / shanker

Use Tcode DBACOCKPIT (ST04) to find SQL statemnts, sort via
the avg elasp time to get expensive SQL statement.

Is This Answer Correct ?

1 Yes

0 No

How are expensive SQL select statements recognized?..

Answer / harsh goel

One way of recognizing them is through aerly watch report.

Is This Answer Correct ?

0 Yes

0 No

How are expensive SQL select statements recognized?..

Answer / madhu arla

using t code st05

Is This Answer Correct ?

0 Yes

0 No