To determine the performance of Replication Agent for Oracle, review the number of archive logs that are generated by Oracle in a period of time and the size of those archive logs.
The archive log history information indicates how much data Replication Agent for Oracle requires to process a replication request.
set linesize 1024
set pagesize 1000
select
sequence# LSN,
to_char(first_time, 'mm/dd/yy hh24:mi:ss') first_time,
to_char(next_time, 'mm/dd/yy hh24:mi:ss') next_time,
to_char(completion_time, 'mm/dd/yy hh24:mi:ss') completion_time,
blocks,
block_size,
first_change#,
next_change#,
name
from v$archived_log
where completion_time > to_date('01/01/14 00:00:00', 'mm/dd/yy hh24:mi:ss')
and name like '/oracle/PRD/oraarch%'
order by sequence#;
where 01/01/14 00:00:00 is the desired time.
See the Oracle documentation for parameter descriptions.