Получение Oracle хинтов (hint) для SQL profile от DBMS_SQLTUNE

select extractValue(value(d), '/hint') hint_text

from (select other_xml, id, attribute

          from user_sqltune_plans

         where task_id = (select task_id

                            from user_advisor_tasks

                           where task_name = 'TASK_SQLSET_mg1')

           and id = 1

           and attribute = 'Using SQL profile' and OTHER_XML is not null) add_data,

 table(XMLSequence(XMLType(add_data.other_xml).extract('other_xml/outline_data/hint'))) d;