SQL & PL/SQL

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!

How to find top 10 highest resource consuming queries

6StringOct 19 2017 — edited Oct 20 2017

SuSE Linux 11, 11.2.0.3 x86-64

Need advice on the best way to identify the top 10 highest resource consuming queries across a given period of time.

I'm thinking ADDM or ASH reports but they won't just give me top 10.

Any assistance would be appreciated.

Thank you for your time

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2017

Added on Oct 19 2017

5 comments

3,785 views