If you know your application well you can probably get parallel threads of
replication going faster (with a little user elbow grease in terms of
specifications). Streams is probably more bulletproof with the attendant
overhead of the computer figuring out more for you (it is not slower because
the Oracle coders are stupid - they are not stupid.) Your mileage may vary.
If I correctly understood the presentation at OOW with Juan and the ex-CEO
and now Oracle employee of Goldengate at the table at the front of the room
and the product manager for Streams in the audience (and brought actively
into the conversational presentation by Juan), the Golden Gate product
methodology is the strategic direction for replication, key bits of Streams
including having the code in your hands instead of having to guess a bit and
reverse engineer will be used to augment and further enhance golden gate.
Streams probably remains strategic for the pathway of doing non-stop
physical dataguard where you do the bit about temporarily switching to
logical dataguard, so I would expect that the streams engine never
For customer benchmarks I observed where the customer understood their
application suite well and could set up parallel threads some of which
didn't have to check back for coordination sync points, Golden Gate was
clearly faster. There may have been a differential in the expertise used to
set up Golden Gate versus Streams in favor of Golden Gate and I cannot
publish those numbers so don't bother asking. But as set up, Golden Gate was
faster. I believe the customer thought it was also easier to understand and
get restarted with less cleanup overhead when something went bump. Some
people have also set up Streams to go very fast (was that you, Kirti?), and
I don't know what the results would have been with a world class configurer
And remember, something always goes bump (usually at the worst time.)
At the time of the OOW presentation Juan said something like, hey, this
acquistion is so new we really only have started to think about how to put
the pieces together and it will take a while to sort out. So take all I've
written with a grain of salt.
On Behalf Of Steff Gonos
Sent: Tuesday, November 24, 2009 5:26 PM
To: dmann99_at_gmail.com; stmontgo_at_gmail.com; oracle-l_at_freelists.org
Subject: Golden Gate
Can you tell me the advantages of using Golden Gate over Streams ?
On Wed, 11/18/09, steve montgomerie wrote:
From: steve montgomerie
Subject: Re: Golden Gate
Date: Wednesday, November 18, 2009, 7:57 AM
Nice WebCast on Golden Gate.
Hope the link works for you. Might be of interest to you.http://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_ext=Y
apparently 64bit form only. Is Golden Gate a purely 64bit product (and yes
know Oracle will integrate/replace streams into this product line) or is
only the 64bit software is up there for now. -- Niall Litchfield ...
I'm not sure what direction they are going since the Oracle buyout but
in the past Golden Gate seemed to have their codebase prepped to build
cross platform and would create binary builds on different platforms
as requested by customers.
I worked on a software product that leveraged Golden Gate TDM for
replication and it seemed every time a big customer bought our product
we were asking Golden Gate for a new build on some new platform. I
know some of these platforms were 32-bit.
www.ba6.us - Database Stuff - http://www.ba6.us/rss.xml