Streams Recommended Patches

Metalink note 437838.1

10.2.0.4

• Bugs fixed:
  • Capture or downstream capture side:
    • 6081550 Tracking Bug for Inventory of Data Guard Logminer/Logical Standby for 10.2.0.3 Includes fixes for Streams capture also
    • 6267873 MLR for Streams/Logmnr bugs 6017440, 6067600,6064864: Install 6081550 first, then remove patch for 6067600 and apply Patch 6267873
    • 6043052 Leak in Perm Allocations with library cache comments ora-4031 generated
    • 4061534 ORA-00600 [KRVTADC] IN CAPTURE PARALLEL PROCESS (using compressed tables)
    • 5604698 DEADLOCK BETWEEN 'LIBRARY CACHE LOCK' AND 'LIBRARY CACHE PIN'
    • 5058318 Memory leak (in "koh-kghu" heap of type "kolccst obj")
    • 5529797 PGA leak / OERI KWQPCBK179 during Streams propagation
    • 5220845 OBJECTS IMPORTED VIA DATA PUMP ARE NOT SHIPPING TO LOGICAL STANDBY
  • Apply side:
    • 6163622 SQL Apply degrades with larger transactions
    • 5093060 Streams: 5000 LCR Limit is causing unnecessary flow control at apply site
    • 5205636 Apply fails with ORA-26687 while dropping a table with referential constraints
• New Bugs:
  • Capture or downstream capture side:
    • 7579469 MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 6599920 and 7363767 (no rolling, special post-install actions)
      • 6599920 STREAMS CAPTURE ABORTS WITH ORA-26744 AND ORA-26773 ON LOB COLUMNS
      • 7363767 addresses performance improvement for capture process and logminer: merge label requesy on top of 10.2.0.4 for Bugs 7345904, 6683178, 6994160, 6413089 and 6650256
        • Bug 7345904 STREAMS CAPTURE SLOW PROCESSING DIRECT PATH INSERT, HIGH CPU FOR LOGMNR BUILDER
        • Bug 6683178 This bug pertains to high latencies in Streams capture, while capturing primary workload with a lot of DDL activities such as truncates of empty tables.
        • Bug 6994160 Capture reader process constantly writing messages to trace file
        • Bug 6413089 Restarting a logminer session can be slow if the session has fallen behind
        • Bug 6650256 For non-logical standby sessions,Parallel DDL (PDDL) transactions are delivered in one chunk which can cause logminer memory spill for Streams, or run slowly during adhoc log mining..
    • 7599054 MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 7480651 7263055
      • 7263055 + 7480651 in order to fix ORA-600 [KWQBMCRCPTS101] when dropping propagation:
        • 7263055 MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 6600051, 6915767 and 6200820 (special post-install actions) / this patch conflicts with April 09 security patch - merge patch available: 8450774
        • 7480651 MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 7207654 and 7377526
    • 5933656 PROPAGATION ORA-600 [KWQPCBK179], [1], [1369]
    • 6827260 EXCESSIVE MEMORY USAGE FOR LCR CACHE DUE TO LARGE FREELISTS
    • 7219752 ORA-26773 MALFORMED REDO ON CAPTURE OF LONG
    • 6640411 PROPAGATION DOES NOT WORK (AQ propogation may fail after changing queue_to_queue=>true)
    • 6452375 ORA-26687 NO INSTANTIATION SCN PROVIDED WHEN DROP CHILD TABLE
    • 6402302 DROP SYNONYM DDL IS NOT CAPTURED/PROPAGATED OR APPLIED
    • 8477406 MERGE PATCH FOR 7331867, 6158910 AND 7579469 (7363767) (special post-install actions)
      • 7331867:LOGMNR CKPTUNSAFECOUNT IS MAINTAINED INCORRECTLY
      • 6158910:MEMORY LEAK LOGMINER BUILDER STREAMS CAPTURE

• • Apply side:
    • 7033630 APPLY ABORTING WITH ORA-600 [KNLQDQM2USR:4] AFTER INSTALLING 10.2.0.4 PATCHSET (special post-install actions)
    • 6838714 APPLY PROCESS IS SLOW AFTER UPGRADING TO 10.2.0.3

10.2.0.3

• Capture or downstream capture side:
  • 6081550 Tracking Bug for Inventory of Data Guard Logminer/Logical Standby for 10.2.0.3 Includes fixes for Streams capture also
  • 6267873 MLR for Streams/Logmnr bugs 6017440, 6067600,6064864: Install 6081550 first, then remove patch for 6067600 and apply Patch 6267873
  • 6043052 Leak in Perm Allocations with library cache comments ora-4031 generated
  • 4061534 ORA-00600 [KRVTADC] IN CAPTURE PARALLEL PROCESS (using compressed tables)
  • 5604698 DEADLOCK BETWEEN 'LIBRARY CACHE LOCK' AND 'LIBRARY CACHE PIN'

• Apply side:
  • 6163622 SQL Apply degrades with larger transactions
  • 5093060 Streams: 5000 LCR Limit is causing unnecessary flow control at apply site

• OEM Agent:
  • 5330663 Unable to start_propagation due to blocking OEM Agent sessions