WARNING: This web is not used anymore. Please use PDBService.StreamsPatches instead!
 

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

Edit | Attach | Watch | Print version | History: r16 < r15 < r14 < r13 < r12 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r16 - 2009-05-14 - EvaDafonte
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback