begin
  sys.DBMS_LOGMNR.ADD_LOGFILE('/mnt/DATABASE_arch/DATABASE_1_321_655345323.arc');
  sys.DBMS_LOGMNR.START_LOGMNR(Options => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
end;

create table redo_sql as SELECT l.SCN, l.TIMESTAMP, l.USERNAME, l.OPERATION, l.SEG_OWNER, l.SEG_NAME, l.SSN, l.RS_ID, l.RBASQN, l.RBABLK, l.RBABYTE, l.DATA_OBJ#, l.REDO_VALUE, l.SQL_REDO from V$LOGMNR_CONTENTS l where seg_owner is not null

with t1 as
        (select rs_id,
                ssn,
                rbablk,
                rbabyte,
                rbablk * 512 + rbabyte curpos,
                lead (rbablk * 512 + rbabyte, 1, rbablk * 512 + rbabyte)
                   over (partition by substr (rs_id, 1, 9)order by
                            rbasqn,
                            rbablk,
                            rbabyte,
                            scn,
                            redo_value)
                   nextpos,
                  lead (rbablk * 512 + rbabyte, 1, rbablk * 512 + rbabyte)
                     over (partition by substr (rs_id, 1, 9)order by
                              rbasqn,
                              rbablk,
                              rbabyte,
                              scn,
                              redo_value)
                - (rbablk * 512 + rbabyte)
                   redo_size,
                operation,
                case
                   when operation = 'INTERNAL' and data_obj# != 0 then
                      (select t0.owner
                         from dba_objects t0
                        where t0.object_id = t1.data_obj#)
                   else
                      seg_owner
                end
                   seg_owner,
                case
                   when operation = 'INTERNAL' and data_obj# != 0 then
                      (select t0.object_name nome
                         from dba_objects t0
                        where t0.object_id = t1.data_obj#)
                   else
                      seg_name
                end
                   seg_name,
                sql_redo,
                redo_value
           from redo_sql t1),
  t2 as (select seg_owner, seg_name, SubStr(SQL_REDO, 1, 50) sql_text, count(*) cnt, sum(redo_size) redo_size from
          (select rs_id, ssn, rbablk, rbabyte, curpos, nextpos, redo_size, seg_owner, seg_name, operation, sql_redo from t1
            order by substr (rs_id, 1, 9), ssn, rbablk, rbabyte, redo_value)
          group by seg_owner, seg_name, SubStr(SQL_REDO, 1, 50))
select Nvl(i.table_name, a.seg_name), Nvl(sql_text, 'INDEX'), sum(cnt), sum(redo_size)
  from t2 a, dba_indexes i
  where i.owner(+)=a.seg_owner and i.index_name(+)=a.seg_name
  group by Nvl(i.table_name, a.seg_name), sql_text
  order by 4 desc

begin
  sys.DBMS_LOGMNR.ADD_LOGFILE('/mnt/DATABASE_arch/DATABASE_1_321_655345323.arc');
  sys.DBMS_LOGMNR.START_LOGMNR(Options => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
end;

create table redo_sql as SELECT l.SCN, l.TIMESTAMP, l.USERNAME, l.OPERATION, l.SEG_OWNER, l.SEG_NAME, l.SSN, l.RS_ID, l.RBASQN, l.RBABLK, l.RBABYTE, l.DATA_OBJ#, l.REDO_VALUE, l.SQL_REDO from V$LOGMNR_CONTENTS l