Search notes:

Oracle: X$XPLTON / X$XPLTOO

x$xplton stores the the names, x$xpltoo the options of steps of an SQL execution plan.
select
   xplton_id,
   xplton_name  operation_name
from
   x$xplton
order by
   xplton_name;
   xpltoo_id,
   xpltoo_name  option_name
from
   x$xpltoo
order by
   replace(xpltoo_name, '(', '');

See also

x$kqlfxpl

Index