Search notes:

Oracle PLAN_TABLE: Column FILTER_PREDICATES

select
   count(*) cnt,
   operation,
   options,
   object_type
from
   v$sql_plan
where
   filter_predicates is not null
group by
   operation,
   options,
   object_type;

See also

There is also a plan operation FILTER
The plan_table and its column access_predicates.
INTERNAL_FUNCTION()

Index