Recommended Patch for Streams
  Doc ID:  Note:437838.1

PURPOSE
-------
Streams can be used for such diverse tasks as  data replication,
data warehousing, database migration between hardware platforms,
application upgrade or migration, and queuing applications.

Below, are some of the key recommendations patches  of Streams in
various version of Oracle database.

SCOPE & APPLICATION
-------------------
Intended for all those who want to know what are the miniimal patches
that needs to be applied before configuring Streams

For any of the following patches if  customers are not able to find via Metalink
Please contact Oracle Support Services

PLEASE NOTE :The list of recommended patches is the same for UNIX and Windows.

Recommended Patches on top of  for 10.2.0.4
============================================
7149004   MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 6683178 6994160 6413089 6650256

 
          6994160 CAPTURE READER PROCESS CONSTANTLY WRITING MESSAGES TO TRACE FILE
          6413089 RESTARTING A LOGMINER SESSION CAN BE SLOW IF THE SESSION HAS FALLEN

BEHIND
          6650256 ALTER TABLE ICE.ALTERNATE_REFERENCE MOVE PARTITION - CAUSES LOGMINER

SPILL
          6683178 CAPTURE PERFORMANCE DEGRADE DUE TO TRUNCATE ON NON-REPLICATED GLOBAL

TEMP TABLES

7263055   MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 6600051 6915767 6200820  

(propagation)
          6915767 ORA-600 [KWQBMCRCPTS101] WHEN REMOVING STREAMS
          6600051 AQRAC:ENQUEUE AND ALTER QUEUE TABLE RESULT IN HANG IN RAC ENV
          6200820 IPC SEND TIMEOUT DETECTED ERRORS BETWEEN QMNC PROCS AFTER RAC

RECONFIGURATION

7033630   APPLY ABORTING WITH ORA-600 [KNLQDQM2USR:4] AFTER INSTALLING 10.2.0.4 PATCHSET 

 
7219752   ORA-26773 MALFORMED REDO ON CAPTURE OF LONG
6838714   APPLY PROCESS IS SLOW AFTER UPGRADING TO 10.2.0.3
6827260   EXCESSIVE MEMORY USAGE FOR LCR CACHE DUE TO LARGE FREELISTS
6628122   CONFLICT RESOLUTION NOT WORKING CONSISTENTLY WITH TIMESTAMP COLUMN
6640411   AFTER CHANGE QUEUE_TO_QUEUE=>TRUE, PROPAGATION DOES NOT WORK 
5933656   PROPAGATION ORA-600 [KWQPCBK179], [1], [1369]
6134664   Maintaining lcrs for a successfully dropped propagation 
4966512   Streams: ORA600 [kwqbcfrobj123 and instance termination AV testing

Bug 7263055 and Bug 6827260  are unpublished bugs.
Contact Oracle Support if there is no one off patch for your platform.

Recommended Patches on top of 10.2.0.3:
========================================
Bug Number Description
1) Remove One off Patch 6067600 (if it has been applied)
2) Remove One off Patch 6067611 (if it has been applied)
3) Install Patch 6081550 Tracking Bug for Inventory of Data Guard Logminer/Logical
   Standby for 10.2.0.3  Includes fixes for Streams capture also 
4) Install Patch 6081547 Tracking Bug for Inventory of Data Guard Physical
   Standby for 10.2.0.3  Includes Bug 5399901 (archived logs can take a
   long time to search [control file])  >> fixes Bug 5399901
5) Install Patch 6267873 MLR for Streams/Logmnr bugs 6017440, 6067600,6064864 
6) Install Patch 6043052 Leak in Perm Allocations with library cache comments Ora-4031

generated    
7) Install Patch 6375952 >> fixes  bugs 6067611,6163622,6440248
8) Install Patch 5093060 Streams:  5000 LCR Limit is causing unnecessary flow
   control at apply site 

Note: MLR Bug 6267873  was re-released after Feb 1, 2008.This patch should be
      re-applied if it was earlier than the re-release date for the specific platform.

Recommended Patches on top of 10.2.0.2:
========================================
Bug Number              Description
10gR2      Recommended Patch Set is 10.2.0.2 (4547817)    
6646179    MERGE LABEL REQUEST ON TOP OF 10.2.0.2 FOR BUGS 6636023 5526410
6043052    Leak in Perm Allocations with Library Cache.    
6196173    Streams Apply patch includes bugs: 4373733, 4446613, 4894027, and 6163622  

Replaces MLR Bug 5113125
5770059    REQUIRED_CHECKPOINT_SCN NOT MOVING FORWARD

 
Recommended Patches on top of 10.1.0.5:
========================================
10gR1 Recommended Patch Set is 10.1.0.5 (4505133)  
Bug Number              Description
4758632    THE LOGMINER READER CONSUMES TOO MUCH CPU TIME WHEN IDLE (5-7%)
5117361    CDC CAPTURE PROCESS ABORTS. ORA-600[KRVXGCTASI:ARRAY SIZE]/
           ORA-1280 IN ALERT LOG
   

10gR1 Recommended Patch Set is 10.1.0.4 (4163362)  
========================================

10gR1 README from 10.1.0.3 Patchset (3761843)
========================================
Required Patches on top of 10.1.0.3
Bug Number                Description
3981404     Streams Megapatch 2 for 10.1.0.3  Released as Bug Number Platform.
3957254              AIX 5L - 64bit
3957254              HPUX- 64bit
3981404              Linux x86
3981404              Linux Itanium
3981404              Solaris 64bit
4074232              Windows
 
9iR2: README from 9.2.0.6 Patchset (3948480)
========================================
This is the generic README from the 9.2.0.6 patch set of the Solaris 32 bit
release.  Note the reference to Metalink Note 283565.1  Be sure to review
this article BEFORE upgrading your database to 9.2.0.6 or 10.1.

The 9206 patchset does NOT include the Special Patch for OMS, OEM client,
and Streams Wizard.  Please be sure to load the patch listed  for
OMS and GUI Streams Wizard as well.

Patchset Installation

After any patchset is applied to an existing streams database, be sure to
perform. in each database, the database migration steps for the patchset.
startup migrate
Streams settings with 9.2.0.6

For best results, implement the following recommendations.

On multi-cpu machines, set the hidden init.ora parameter _kghdsidx_count=1.

For streams memory control, the hidden parameter, _first_spare_parameter,
allows DBAs to control the shared_pool memory threshold (%) at which the
Streams buffer queue will begin to spill-over to disk.
Recommendation:  double the shared_pool_size and set the hidden init.ora
parameter _first_spare_parameter=50 (for 50% of the shared_pool_size parameter)

In addition , use the manual flow control scripts available on Metalink or
Note 259609.1

Bug 3023858 Streams OEM GUI and Oracle Management Server patch

Recommended Patches on top of 9.2.0.5
========================================
9iR2: README from 9.2.0.5 Patchset (3501955)
For best results, implement the recommendations listed in 9.2.0.6 above.
Bug Number                       Description
3464629 Logmnr_spill$ table grows in unbounded fashion  
3023858 Streams OEM GUI and Oracle Management Server patch
See comments below
Bug 3754130 Captured_scn, Applied_scn not updating -
logmnr checkpoints not completing  With this patch _CHECKPOINT_FORCE
will also recompute the active DDL count used to determine if a
checkpoint can be taken. 

Recommended Patches on top of 9.2.0.4.
========================================
README from 9.2.0.4 Patchset (3095277)
Bug 3314371 --This Merge label request  contains the following fixes: 
3157924, 3155220, 3150982, 3147518, 3120228, 3231190, 3234793, 3263696,
3272219, 3170326, 3167779, 3192519, 3210086, 2442042, 3260252, 2836515,
3109703, 3231109, 3232401, 3249271, 2566043, 3269297

Bug 3023858 Streams OEM GUI and Oracle Management Server patch

===Eof==