When the following is received from the APPLY process:
2013/06/20 21:00:33 WARN> WARN-3111: Apply SQL is running too long, please investigate the execution plan. Maybe you need to add some indexes? (Time spent so far: 39 seconds, SID = 154, SQL: insert into OE."LOGON" (CUSTOMER_ID,LOGON_DATE) values (:1, :2) ) 2013/06/20 21:00:33 INFO> Apply progress: 630709 LCRs processed. 2013/06/20 21:00:44 WARN> WARN-4504: Error trying to return data for command /engine/accept_remote_command: Broken pipe. Bytes to send: 98, bytes sent: 0 (server).
v$session for any locks.
The APPLY process will have stopped. Please
restart the APPLY process.
Arjen Visser June 21, 2013 18:24