Oracle Monitor

ORA TNS


SELECT distinct (message_text) , count(1)
FROM x$dbgalertext
where 1=1
and  originating_timestamp > sysdate - 1/24
and  message_text like 'ORA-%' or message_text like 'TNS-%'
group by message_text