Full Table Scan queries history

Haytham Mostafa

Hello,

Is there a way to find the history of the queries which performed full table scan recently or in specific date ?

Thanks

4007441

Hi,

You can make use of v$sql_plan or dba_hist_sql_plan views to figure out the queries performed FTS.

select * from dba_hist_sql_plan where operation = 'TABLE ACCESS' and options = 'FULL';

Thanks!

EdStevens

Note that use of dba_hist_sql_plan requires additional licensing.