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!

Query to Find Top Hitting Queries on a Table

RamarajuNov 7 2018 — edited Nov 8 2018

Hi All,

We have a requirement from the client side. We need to identify what are the top queries that are hitting the particular table in EBS database.

Could you please help how to find those top hitting queries on a particular table and query hitting counts?

EBS: R12.2.7

DB: 12.1.0.2.0

Thanks,

Ramaraju

Added on Nov 7 2018

#general-database-discussions

8 comments

999 views