cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Full Table Scan Queries Identification

Babar_Qayyum
DynaMight Guru
DynaMight Guru

Dear All,

Is it possible to identify the SQL queries doing the full table scan?

Regards,

Babar

2 REPLIES 2

Julius_Loman
DynaMight Guru
DynaMight Guru

No, unfortunately. Processing of SQL queries is performed by the relational database, the database decides if there is a need for a full table scan. As applications are not aware of that, Dynatrace Oneagent cannot capture such information.  

For Oracle, the Dynatrace Oracle Insights will help you as it will allow you to see the most consuming statements and download execution plans.

Certified Dynatrace Master | Alanata a.s., Slovakia, Dynatrace Master Partner

Hello @Julius_Loman 

Thank you for your comments. We are monitoring several databases through Oracle Insights but there are 100s of databases, so I was looking at the subject option to alert the respective teams for their necessary actions.

Regards,

Babar