Oracle event 26749 - for Streams propagation batch size

From: krishna sarabu <>
Date: Tue, 12 May 2009 15:21:43 -0700 (PDT)
Message-ID: <>


I came across a document from CERN that talk about the following Oracle event to reduce the Oracle Streams acknowledgements to improve Streams performance.
            alter system set events '26749 trace name context forever, level 2';

From the Oracle error description:
            oerr ORA 26749:        
                        26749, 00000, "STREAMS propagation batch size"

Can anyone please explain what exactly the purpose of this event and its usage?

Thanks in advance.

Received on Tue May 12 2009 - 17:21:43 CDT

Original text of this message