GENERIC_PLAN_OBJECT
GENERIC_PLAN_OBJECT
is the base type from which a few specialized objects derive:
select
type_name
from
dba_types
where
supertype_name = 'GENERIC_PLAN_OBJECT'
order by
type_name;
--
-- ADVISOR_OBJECT
-- AWR_OBJECT
-- CURSOR_CACHE_OBJECT
-- PLAN_TABLE_OBJECT
-- SPM_OBJECT
-- SQLSET_OBJECT
-- SQL_PROFILE_OBJECT
An instance of
generic_plan_object
is used in the procedure
compare_plans
of
dbms_xplan
:
select
package_name,
object_name as func_or_proc_name ,
argument_name
from
dba_arguments
where
type_name = 'GENERIC_PLAN_OBJECT';
There is also a table of generic_plan_object
:
select type_name from dba_coll_types where elem_type_name = 'GENERIC_PLAN_OBJECT'
--
-- PLAN_OBJECT_LIST