Compare repair process hangs on target (4297387)

Compare repair process hangs on target

Compare repair is stuck and does not move on target; compare client uses a lot of CPU

1. Compare is running, but does not complete.

sp_ctrl (rep_splex:2800)> show compare id 17504.1

Host: rep_splex

ID Tablename Since Repair
-------- ------------------------------------------ ------------------ ------
17504 "SP2800"."DEMO_SRC" 16-May-12 17:05:12 On

Source table : "SP2800"."DEMO_SRC"
Target table : "SP2800"."DEMO_DEST"
Target route : dest2800@rep
Where clause :
Select hint :
Compare state : Comparing & Repairing
Processed (%) : 0.0 %
Inserts needed : N/A
Updates needed : N/A
Deletes needed : N/A

2. On target, sp_declt uses a lot of CPU.

[oracle@dest2800 log]$ top

top - 17:17:00 up 8:25, 3 users, load average: 4.08, 4.40, 4.59
Tasks: 873 total, 2 running, 871 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.0%us, 0.9%sy, 0.0%ni, 95.9%id, 1.8%wa, 0.0%hi, 0.5%si, 0.0%st
Mem: 263891312k total, 263521448k used, 369864k free, 474396k buffers
Swap: 32764528k total, 307228k used, 32457300k free, 255375512k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
22716 oracle 18 0 46024 10m 8008 R 97.6 0.0 11:04.69 sp_declt