Query to find out FULL table scan and table extent in a database

1) The below query will provide all the select statement which is using FTS in the whole database.

SELECT SQL_ID,OPERATION,OPTIONS,OBJECT_NAME,OBJECT_OWNER
FROM V$SQL_PLAN
WHERE OPTION like ‘%FULL%’ AND OPERATION like ‘%TABLE%’;

–Then find the Query Text :
SELECT SQL_ID,SQL_TEXT
FROM V$SQL
WHERE SQL_ID in (
                           SELECT SQL_ID
                           FROM V$SQL_PLAN
                           WHERE OPTIONS like ‘%FULL%’ AND OPERATION like ‘%TABLE%’
                          );