It's not *really* as simple as that. What about a join that uses an index for one table, and not for another? Anyway, a quick approximation would be:

select s.sql_id, s.sql_text
from v$sqlstats s,
( select distinct sql_id
  from v$sql_plan
  where options like '%FULL%'
) p
where p.sql_id = s.sql_id

but are you sure that is *goal* here. Who cares if they are indexed or unindexed ? I thought perhaps the thing of interest really is "what queries are slow?"

For that you can also use v$sqlstats, and look at high values for:

executions
buffer_gets
disk_reads
elapsed_time