topic Full Table Scan Queries Identification in Open Q&A

Full Table Scan Queries Identification

Babar_Qayyum — Mon, 03 Jan 2022 08:50:27 GMT

Dear All,

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

Regards,

Babar

Re: Full Table Scan Queries Identification

Julius_Loman — Sun, 02 Jan 2022 10:34:00 GMT

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.

Re: Full Table Scan Queries Identification

Babar_Qayyum — Sun, 02 Jan 2022 11:52:26 GMT

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