VIEW: SYS.DBA_ADVISOR_EXECUTION_TYPES

Source

View Text - Preformatted

select d.name advisor_name, e.name execution_type,
            dbms_advisor.format_message(e.description) execution_description
  from wri$_adv_definitions d, wri$_adv_def_exec_types e
  where d.id = e.advisor_id

View Text - HTML Formatted

SELECT D.NAME ADVISOR_NAME
, E.NAME EXECUTION_TYPE
, DBMS_ADVISOR.FORMAT_MESSAGE(E.DESCRIPTION) EXECUTION_DESCRIPTION
FROM WRI$_ADV_DEFINITIONS D
, WRI$_ADV_DEF_EXEC_TYPES E
WHERE D.ID = E.ADVISOR_ID