RE: Golden Gate
Date: Thu, 26 Nov 2009 08:22:23 -0500
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 disappears.
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 of Streams.
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.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
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 Cc: 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 <stmontgo_at_gmail.com> wrote:
From: steve montgomerie <stmontgo_at_gmail.com>
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 <http://www.oracle.com/webapps/dialogue/dlgpage.jsp?p_ext=Y&p_dlg_id=8286503 &src=6878223&Act=31&msgid=8287286&eid=3927988045&lid=1> &p_dlg_id=8286503&src=6878223&Act=31&msgid=8287286&eid=3927988045&lid=1
On Tue, Nov 17, 2009 at 10:14 AM, David Mann <dmann99_at_gmail.com
<http://us.mc327.mail.yahoo.com/mc/compose?to=dmann99_at_gmail.com> > wrote:
> Niall Litchfield wrote:
>>I see that Golden Gate software is now available for download from Oracle
>>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 ...
> Hi Niall,
> 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.
> Dave Mann
> www.ba6.us - Database Stuff - http://www.ba6.us/rss.xml