Search notes:

Oracle PLAN_TABLE: column ACCESS_PREDICATES

The value of the plan_table column access_predicates lists the predicates that are used to locate rows, for example as start/stop predicates in an index range scan. 
select
-- count(*),
   operation
-- options
from
   v$sql_plan
where
   access_predicates is not null
group by
    operation
--  options
order by
   operation
--
-- BITMAP INDEX
-- CONNECT BY
-- HASH JOIN
-- INDEX
-- SORT
-- TABLE ACCESS

See also

The plan_table and its column filter_predicates.

Index