Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Which query do you use in order to detect long running queries?

ronald_2017Nov 19 2019 — edited Nov 21 2019

Hi All,

For Oracle 11g, which query do you use in order to find long running queries? I know there might be many ways in order to detect long running queries. However, I am just wondering what's is your strategy?

Do you recommend v$sql elapsed_time? I often use it.

Regards

This post has been answered by tsangsir on Nov 20 2019

Jump to Answer

Added on Nov 19 2019

#general-database-discussions

15 comments

14,904 views