My Oracle Support Banner

Advanced Replication Parallel Push Extremely Slow (Doc ID 362976.1)

Last updated on DECEMBER 12, 2011

Applies to:

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


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
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


To view full details, 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 a vibrant support community of peers and Oracle experts.