col task_name form a5
col segname form a30
col type form a15
col message form a80

select ao.type, 
       ao.owner || '.' || ao.attr2 || decode (ao.attr3, '', '', '(' || ao.attr3 || ')') segname,  
       af.message 
from dba_advisor_findings af, dba_advisor_objects ao
where ao.task_id = af.task_id
and ao.object_id = af.object_id
and ao.owner = '&object_owner'
order by 1, 2