col sql_undo format a40
col sql_redo format a40
select to_char(timestamp,'DD hh:mi:ss') xx,sql_undo,sql_redo from v$logmnr_contents where username='CTXSYS' 
and to_char(timestamp,'DDhh24mi') > '311510'
and to_char(timestamp,'DDhh24mi') < '311525'
--and rownum < 20
order by 1 desc
/