sql_doing_fts.sql

select sql_text

from V$sql a,

v$sql_plan b

where a.address = b.address

and a.hash_value = b.hash_value

and b.operation = ‘TABLE ACCESS’

and b.options = ‘FULL’

and b.OBJECT_OWNER <> ‘SYS’

/