Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hw is Sharelex ?

RE: Hw is Sharelex ?

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Mon, 11 Oct 2004 19:12:57 +0200
Message-Id: <1097514777.12712.129.camel@dbalert199.dbalert.nl>


The reason I didn't answer before is that I don't like (to put it nicely) questions broadcasted across the whole world, (OKAY, just 4 mailinglists, but that's the same). However, I feel urged to react because a proper alternative isn't mentioned during the lifetime of this thread. I think Oracle is doing a good job with Data Guard, and I'd like to advocate that nice and free (EE required) option. The LONG column problem has been addressed in 10g. With 10g I see few reasons (if any) not to consider Data Guard (Logical Standby/SQL Apply). As mentioned, if you have EE you have it already, for free (more or less). Shareplex is far from free. Queueing is outside your database (in your redo/archived redo) with Data Guard. Management is not that difficult anymore. Appr. 6 mouseclicks and a couple of keys (if you want to overrule defaults) in GC is all you need to instantiate a standby database. Of course I don't like GUI's, I do it the hard way, with command lines and scripts. The 6 mouseclicks was Physical, no time yet to do Logical on 10g, but at least put it on your shortlist.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Mon, 2004-10-11 at 18:18, Mark Strickland wrote:

> I implemented Shareplex at a previous contract assignment for a simple
> reporting database. It was easy to implement and easy to maintain. The
> driving reason for using Shareplex was that the data model involved had
> LONG columns. A major advantage with Shareplex is that the queueing of
> transactions occurs outside the database so there is less risk of space
> issues if replication falls behind (the only times that Shareplex fell
> behind for me was due to my own error). =20
>
> Mark Strickland
> Seattle, WA
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chirag DBA
> Sent: Saturday, October 09, 2004 12:21 AM
> To: oracle-l_at_freelists.org; askdba_at_freelists.org;
> dba_gurus_at_yahoogroups.com; oracle-dba-masters_at_yahoogroups.com
> Subject: Hw is Sharelex ?
>
> Hi Friends,
>
> Is any one using the SHAREPLEX of Quest Software ?
>
> Is that a good idea to get good command of DATABASE REPLICATION
> TECHNOLOGY n mainly work in that side?
>
> Hw is the market demands for the REPLICATION EXPERT ?=20
>
> - Chiku
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 11 2004 - 12:03:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US