RE: SharePlex

Actually, logical standby database does have a hidden cost because you need Data Guard which is licensed
separately. The product that mimics SharePlex is called Oracle Streams and it is a redo log based replication
tool, sort of Logminer on steroids. By the way, logminer was published because of the Quest who reengineered
the format of redo logs and based recovery mechanism on reading the changes from the logs and applying
them to "replicated" database. Neither logminer, SharePlex nor Streams can handle DDL. One has to propagate
schema changes using Quest Schema Manager or the same thing from Embarcadero or, for masochists, OEM Change
Management Pack. I used every expletive in the book while I was testing OEM and I even invented a few of my own.
If you opt for any of those tools (and Data Streams is a pretty cool stuff, based on the demos, white papers from OTN, marketing brochures and spam about the database enlargement), you will also need a schema manager tool.
Quest Schema Manager is a very good tool which I tested extensively. I'f you decide to go cheap and use trigger/stored procedures based replication ("advanced replication"), you'll need a gun, preferrably 44-magnum. That is known as "go ahead, make my data" option. Do you feel lucky?    

--
Mladen Gogala
Oracle DBA 


-----Original Message-----
Goulet, Dick
Sent: Friday, August 08, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L


Nelson,
 
    SharePlex does the same basic thing that Oracle does for the logical
standby, as a matter of fact if your running 9i why not use that instead of
Quests's pricey tool?  I don't believe there is any additional cost to using
logical standby over the second server license that your going to have to
pay anyway.
 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA 

-----Original Message-----
Sent: Friday, August 08, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L



Hello, 

Quest is trying to sell us a product named SharePlex.  It sounds very
attractive, but then sales people are supposed to be good at that.  We are a
mid sized company, about 2.2 billion per year, running Financials 11.5.7.
We are interested in this for HA and for reporting instance use.  

<rant> 
We use Cognos as our query tool and the owners of this product tells me that
we can't tune the SQL it emits.  It makes pretty poor choices, which is not
surprising for a gooey, sticky tool designed for end users.  It is sort of
pretty and if you can drool you too can generate cross products.  Anyway ,
I'd like to get them off the production box.

<rant/> 

Does SharePlex allow you to stay close to the production instance in time?
Does the store and forward work well?  Do you love it?  Hate it?  Anything
you'd like to say about this product I'd like to hear

Thanks in advance 
  


	Allan L. Nelson
Oracle DBA 
M-I L.L.C.


(832) 295-2238 office

(832) 351-4180 fax

anelson_at_midf.com < <mailto:anelson_at_midf.com> mailto:anelson_at_midf.com> 



____________________________________________________________________________
__
This email is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Copying, forwarding or distributing this message by persons or entities
other than the addressee is prohibited. If you have received this email in
error, please contact the sender immediately and delete the material from
any computer. This email may have been monitored for policy compliance.
[021216]



--------------------------------------------------------
Note:
This message is for the named person's use only.  It may 
contain confidential, proprietary or legally privileged 
information.  No confidentiality or privilege is waived 
or lost by any mistransmission.  If you receive this 
message in error, please immediately delete it and all 
copies of it from your system, destroy any hard copies 
of it and notify the sender.  You must not, directly or 
indirectly, use, disclose, distribute, print, or copy 
any part of this message if you are not the intended 
recipient. Wang Trading LLC and any of its subsidiaries 
each reserve the right to monitor all e-mail 
communications through its networks.

Any views expressed in this message are those of the 
individual sender, except where the message states 
otherwise and the sender is authorized to state them 
to be the views of any such entity.
---------------------------------------------------------


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).