Search notes:

Oracle PLAN_TABLE: column OBJECT_TYPE

Values of object_type in plan_table include
CLUSTER
INDEX
INDEX (BITMAP)
INDEX (CLUSTER)
INDEX (UNIQUE)
PROCEDURE
SEQUENCE
TABLE
TABLE (FIXED)
TABLE (TEMP)
VIEW
VIEW (FIXED)

PROCEDURE

The value of object_type is PROCEDURE if the plan operation is COLLECTION ITERATOR (PICKLER FETCH). 
explain plan
   set statement_id = 'pickler-fetch'
for
   select * from table(dbms_xplan.display);


select
   operation,
   options,
   object_type,
   object_owner,
   object_name
from
   plan_table
where
   statement_id = 'pickler-fetch';

See also

This matrix shows which object types are accessed by plan operators.

Index