Advanced Replication Parallel Push Extremely Slow (Doc ID 362976.1)

Last updated on DECEMBER 12, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.2 - Release: 9.2 to 10.2
Information in this document applies to any platform.

Symptoms

Advanced replication parallel push is very slow. Serial push is not affected. On the receiving
site, trace files with a signature similar to the following are generated:



*** SERVICE NAME:(repl2) 2006-02-07 08:59:29.253
*** SESSION ID:(147.1067) 2006-02-07 08:59:29.253
knipdis ---------
*** 2006-02-07 08:59:29.283
userid: 30
sname:FISH
oname:TESTREP$RP
opname:REP_UPDATE
knipgusql: update -------------------
update /*+ streams */ "FISH"."TESTREP" p set "ID"=decode(:1,'N',"ID",:2),
"TEXT"=decode(:3,'N',"TEXT",:4) where (:5='N' or(1=1 and
decode(:6,'N','Y',decode(:7,"TEXT",'Y'))='Y')) and(:8="ID")
knipdmpargs: dump old argument list:
column: "ID"
value = 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms