Although Streams is a goner, (Golden Gate taketh over…) My notes on performance considerations when utilizing streams as I work with it is always valuable.  These came from a number of blogs, notes from Oracle and simple grief, so thought I would share… 🙂 1. TYPE OF DATA REPLICATION Due to the way this table is loaded, we need to be concious of “queue spill”. Queue spill, per Oracle’s support documentation, is associated with LCR’s not being processed in a timely fashion per interval from the buffered queue, resulting in the old LCRs to “spill” from memory out to disk…