select a.object_name,a.sql_id,b.sql_text,max(b.executions) executions,max(b.last_active_time) last_active_time,b.first_load_timefrom v$sql_plan a, v$sql bwhere a.sql_id = b.sql_idand a.object_type = 'TABLE'and a.options = 'FULL'and a.object_name not like '%$%'group by a.object_name, a.sql_id, b.sql_text, b.first_load_time;