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