Use TOAD, only over archived redo otherwise you get ORA-07445: exception encountered: core dump [skgfospo()+1736] [SIGBUS] [Invalid address alignment] [0x5A] [] []
Query for log mining
select count(*), seg_owner, seg_name, seg_type_name, operation
from V$LOGMNR_CONTENTS
group by seg_owner, seg_name, seg_type_name, operation
order by 1 desc
--result
--OBLICORE.Q_MESSAGE_ALERT_LOG
--OBLICORE.Q_MESSAGE_DASHBOARD_EVENTS
Select *
From V$LOGMNR_CONTENTS
where seg_owner = 'OBLICORE'
and seg_name in ('Q_MESSAGE_ALERT_LOG', 'Q_MESSAGE_DASHBOARD_EVENTS')
and not operation in ('UNSUPPORTED', 'COMMIT', 'INTERNAL', 'START') |