- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 9:34 AM
You know, from a logistics perspective I'm interested in something here
that
maybe those that use SharePlex can cast some light on.
The only Oracle supported
with
Oracle. Oracle development can't do that so neither can we.
Allan
-Original Message-
Sent: Wednesday, November 05, 2003 5:34 PM
To: Multiple recipients of list ORACLE-L
You know, from a logistics perspective I'm interested in something here
that maybe those that use SharePlex can cast
Hi,
We are evaluating using either Oracle logical standby or Quest Shareplex
replication for reporting purposes. It appears that there are quite a few
datatypes not supported by Logical standby. Anyone knows what datatypes are
not supported by shareplex replication? Tried looking up at quest
I forgot to mention we're looking at Shareplex 4.5. I found DDLs and
datatypes not supported on version 4.0 but not on 4.5.
Thanks.
elain
From: elain he [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: shareplex: datatype unsupported
Date: Wed, 05 Nov 2003 07:01:44 -0500
Hi,
We are evaluating
Please bear in mind that there is one thing in a datatype being supported and another
in all functions and features of Shareplex being usable when that datatype is involved.
I am thinking about datatype long specifically.
We have been replicating a 8i database (tru64) to a 9i one (sun)using
We are working on a SharePlex project here although we are still in
test/pilot phases. We are in an apps 11i environment with an 8.1.7.4
database. So far, we have found that index organized tables are not
supported. In addition, in financials, there is a table named
hz_locations that has a UDT
are evaluating using either Oracle logical standby or Quest
Shareplex
replication for reporting purposes. It appears that there are quite a
few
datatypes not supported by Logical standby. Anyone knows what
datatypes are
not supported by shareplex replication? Tried looking up at quest
website
That goes for Shareplex too (sorry to state the obvious). I've been
seriously bitten in recent weeks by problems with their stuff too.
_
Tim Onions
Head of Oracle Development
Speech Machines (A MedQuist Company)
...the speech-to-data Application Service Provider
You know, from a logistics perspective I'm interested in something here that
maybe those that use SharePlex can cast some light on.
The only Oracle supported mechanism for mining the redo logs is LogMiner,
yes? Now, given that we can change the format of the redo logs from release
to release
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: shareplex: datatype unsupported
Date: Wed, 05 Nov 2003 15:34:25 -0800
You know, from a logistics perspective I'm interested in something here
that
maybe those that use SharePlex can cast some light on.
The only Oracle supported mechanism
Hi gurus,
Oracle 8.1.7.3 on Sun Solaris
One of our databases has been updated by Shareplex, and we have a huge
performance problem
Shareplex is the only process running on this database.
Here is the output of v$session_event
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
With 2 CPUs, a Run-Queue of 1.27 isn't high. As SharePlex seems to be
the only process taking CPU, it is taking 100% of 1 CPU. If it is one
process only,
then the CPU speed __could__ [and I'm not saying IS] the constraint.
Adding CPUs wouldn't help. However, upgrading to a faster CPU would
databases has been updated by Shareplex, and we have a huge
performance problem
Shareplex is the only process running on this database.
Here is the output of v$session_event
SID EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED
AVERAGE_WAIT
Allan,
I don't know about the source machine.
I receive around 350Megs of data every day.
I'm using sp_ctrl to stop and restart my Post process and monitor the queue.
I'm pretty sure that the bottleneck come from Shareplex. Oracle is waiting
for Shareplex, we have server's resources available
Dan,
The process taking 50% is an Oracle process and it is connected on Shareplex
Oracle user.
I have two different error messages:
1- System call error: sp_cop(dsm) Temporary error (h_errno = 2)
gethostbyname (can't add entry for ora4)
I got this error every 10 minutes, but I didn't find
Shareplex is fast here. We replicate a 6 CPU db to a 4 CPU machine
without excessive loads or problems. We run an average of 29 messages
with about 1 GB in the queues. Our data is 0 minutes old.
Outside of contacting Quest support I'm sure of how much help I can be.
When I have seen SP claim
that the bottleneck come from Shareplex. Oracle is
waiting
for Shareplex, we have server's resources available (CPU is 50%
idle).
How can we speed up Shareplex?
Luc
-Original Message-
Sent: October 23, 2003 12:56 PM
To: Multiple recipients of list ORACLE-L
How big is the box that is the source
Now we don't use Shareplex, but I do know of others who do this is not the first
time I hear of performance problems, but I may be able to shed some light on the
problem. Since Shareplex reads the redo logs, if one statement on the source database
affects more than one row (lets say 10
-
Sent: Thursday, October 23, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Dan,
The process taking 50% is an Oracle process and it is connected on
Shareplex Oracle user.
I have two different error messages:
1- System call error: sp_cop(dsm) Temporary error (h_errno = 2)
gethostbyname
on this order could be the problem.
Allan
-Original Message-
Sent: Thursday, October 23, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Now we don't use Shareplex, but I do know of others who do this is not
the first time I hear of performance problems, but I may be able to shed
some light
.
Allan
-Original Message-
Sent: Thursday, October 23, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Now we don't use Shareplex, but I do know of others who do this is not
the first time I hear of performance problems, but I may be able to shed
some light on the problem. Since
arly since data integrity is usually enforced in thesource db you can typically disable it in the target. I supposesomething on this order could be the problem.Allan-Original Message-Sent: Thursday, October 23, 2003 2:29 PMTo: Multiple recipients of list ORACLE-LNow we don't use Shareplex, but
One of my clients has been talking to me about similar issues.
What kind of system are you replicating?
How much redo logging are you generating per day?
Does shareplex start to fall behind during the processing peaks?
_
David Kurtz
Go-Faster Consultancy Ltd.
tel: +44 (0
Title: Message
Sorry about the late reply but (if I remember
correctly from my research about one year ago) Shareplex does something like log
mining only on Unix systems. On NT it uses triggers just like
replication.
Yechiel AdarMehish
- Original Message -
From:
Aponte
Title: Message
Shareplex does not use triggers on NT it uses the same underlying
technology as it does on Unix "reading" the log files and shipping SQL to the
target database. It uses a 3rd party tool called "Knutcracker" to allow it to
some ofits UNIX commands on
Title: Message
Tony,
My
question was inspired by belief that SharePlex does log mining on the source DB
and hence do not send unnecessary data over the network. Apparently, this is not
the case. I didn't want to compare SharePlex to logical standby cause I know
that logical standby
Title: Message
You
are correct in the first place. SharePlex works as you describe, it mines
the log and sends only the absolute minimum to reassemble the transaction on the
target. It doesn't send SQL. The target side processes take the data
and rebuild a SQL statement from the DDL
Hi there
In the past few weeks, there have been lots of discussion about HA, data
replication
and using Shareplex, dataguard, Streams, logical physical
standby. As most of you
have found out each has it own pros and cons. You also need two
sets of Database licences
and Shareplex licences
Title: Message
Hi All,
I'm trying to find some technical
details about SharePlex, that is:
- How much network bandwidth I'd
expect to replicate from database, generating 1-5 MB/sec redo.
DoesSharePlex send SQL text over the network or data in some internal
(hopefully compressed)format
1)You would need lessnetwork bandwidth with shareplex than you would for transporting archive logs. about 1/3 rd ofwhat you would need for physical stdby.
2) CPU burden would be 'little' I guess.
3) Shareplex replication allows you to have the table available for read on the target. (even update
and
spend your money elsewhere.
Physical standby and shareplex can operate on
archivelogs, thus they can do their jobs without any additional burden to source
database CPU, since you generate and archive your logs anyway. You can do
archivelog's processing on target or some staging server.
Tanel
Thank
you, Raju. Very helpful
-Original Message-From: raju pa
[mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:59
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
SharePlex info
1)You would need lessnetwork bandwidth with shareplex than
you would
maintenance, etc.) is not used by
Shareplex.
In our
environment of dual Sun 6800's, 10 CPU's each, we observe less that 1% CPU
consumption on the source and target sides combined. It varies according
to the DML load on the source but not by much. We've never had a problem
with it consuming
: Thursday, August 21, 2003 5:14
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
SharePlex info
Hi!
Btw, you can physically replicate 50% of your
tables with regular standby mechanisms as well. You just take the files
belonging to non-needed tablespaces offline and standby recovers
But you would be wanting to transfer *full*
logfiles away from your production servers anyway at least if your data is
worth something...
Tanel.
1)You would need lessnetwork bandwidth with shareplex than
you would for transporting archive logs. about 1/3 rd ofwhat you
Title: Message
Ok, in this case Shareplex might be better, if it
is able to extract only relevant data from logs.
Actually, you could dosomewhat similar
yourself using logminer as well. You just extract all needed DML statements on
either production or staging server, compress the output
steam must be passed over the network anyway. 5 MB/sec over WAN. So we'are doing research if we could same some bandwidth.
Vadim
-Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Re: SharePle
: Friday, August 22, 2003 2:14
AM
Subject: RE: SharePlex info
Yes. A nice neat trick indeed. Has anyone tried this?
About your redo generation : 5MB/sec - 18000 MB/hour ==
18GB
IT is indeed huge. IS this peak or average? Good luck.
"Gorbounov,Vadim" [EMAIL
On 2003.08.09 17:14, Indy Johal wrote:
As Nelson is not in Oracle 9i, And so the option availbale with him are
Who or what is Nelson? There was a guy named Horatio Nelson who died at
Trafalgar after tasting too much of French food and was widely followed
by the paparazzi of the time because of his
PROTECTED]
cc:
First thanks to every one who responded both on the list and to my private
email:
The consensus appeared to be:
1. SharePlex is overly expensive for the functionality delivered and 2. Oracle has
caught up in 9i for much of the functionality 3. Some features of Oracle like
.
Allan
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 3:30
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex Summary
No
penalty. HP-UX is 64-bit os running on a 64-bit chip. Why would 64 bits impose
any
: SharePlex I could access oraclestore today and didn't see neither DataGuard norStreams in database additions section (where RAC, Data Mining and othersare).Then did a product search on dataguard, data guard, standby - got nopositive results...But maybe the sales guys have other story... I've luckily
-Original Message-From: Nelson, Allan
[mailto:[EMAIL PROTECTED]Sent: Friday, August 08, 2003 3:44
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex
We are
not running 9i but 8.1.7.4, sorry for not including that earlier. We
are rolling out to our international offices
Title: SharePlex Summary
First thanks to every one who responded both on the list and to my private email:
The consensus appeared to be:
1. SharePlex is overly expensive for the functionality delivered and
2. Oracle has caught up in 9i for much of the functionality
3. Some features
. On the other hand, who will ever need more then 640K
RAM?
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Nelson, AllanSent: Tuesday, August 12, 2003 10:49
AMTo: Multiple recipients of list ORACLE-LSubject:
SharePlex
to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
First thanks to every one who responded both on the list and to my private
email:
The consensus appeared to be:
1. SharePlex is overly expensive for the functionality delivered and
2
Title: SharePlex
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
Allan
As to your Shareplex comments, I'm in no position to support or refute
your conclusions. My admittedly brief experience with replication leads me
to the conclusion that there are no simple conclusions. If ever there was an
area where your mileage may vary, this is it. Replication
Title: SharePlex
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
PROTECTED]Sent by: [EMAIL PROTECTED]08/09/2003 05:34 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: bcc: Subject: Re: SharePlex On 2003.08.09 17:14, Indy Johal wrote: As Nelson is not in Oracle 9i, And so the option availbale with him areWho
, for example. This may createsome inconveniences to users though.Note that even when running Apps on shareplex-replicated-standby-databaseisn't probably supported, then for Cognos it doesn't matter, it only dealswith content of tables anyway, and SP should be able to tranfer datacorrectly.- I had
, one solution would be to just to recover
standby database few times a day, at lunchtime, for example. This may create
some inconveniences to users though.
Note that even when running Apps on shareplex-replicated-standby-database
isn't probably supported, then for Cognos it doesn't matter, it only
Title: Message
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
Title: SharePlex Summary
Allan,
We use HP-UX 11.o 11i with 817 9i. No
difference that I've noticed. Actually 9i seems to perform
better.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Nelson, Allan
[mailto:[EMAIL PROTECTED]Sent: Tuesday
Title: Message
Cool,
I'll give 9i a try on HPUX.
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:19
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex Summary
Allan,
We use HP-UX 11.o 11i with 817
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Nelson, AllanSent: Tuesday, August 12, 2003 4:44
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
SharePlex Summary
Yes
we are PA risc rather than Itanic. The analysis I heard was the 64 bits
(8
Is your first sentence a bit of an understatement Nick ? If so I suppose you can call
your points 'leading' questions like lawyers use to trap a defendant
We use Shareplex and I have seen some of your posts on the subject (and still have
them in my saved box)
John
-Original Message
Ha, been there done that
Not an uncommon event as I understand it.
John
-Original Message-
Sent: 09 August 2003 23:59
To: Multiple recipients of list ORACLE-L
I'll add one to the list:
nnn) How much downtime and DBA time is required when the Shareplex replication queues
get
Hi!
--- I don't meant to say Logical standby here as
Logical Standby databasse can never be Realtime as they work like streams in
Asynchronous manner. THe only option available fo Synchronous data movement is
with Oracle advance replication or Physical standby Database where it can
Title: Message
We are
not running 9i but 8.1.7.4, sorry for not including that earlier. We
are rolling out to our international offices and we basically have offices in
every time zone. I'm looking at SharePlex for HA, reporting use, and
potentially migrating from HP to Linux
On 2003.08.09 17:14, Indy Johal wrote:
As Nelson is not in Oracle 9i, And so the option availbale with him are
Who or what is Nelson? There was a guy named Horatio Nelson who died at
Trafalgar after tasting too much of French food and was widely followed
by the paparazzi of the time
MladenActually your statement that Neither logminer, SharePlex nor Streams can handle DDL is not correct. With Oracle 9 logminer it is possible to capture DDL and so the Stream capture DDL as it uses logminer at the back. As Nelson is not in Oracle 9i, And so the option availbale with him
On 2003.08.09 09:39, Tanel Poder wrote:
MessageHi!
Mladen, does DG really have additional fee when using EE? I tried to check
from oraclestore, but got - instead:
Tanel, my @#$%! Adelphia Cable connection is down more or less throughout the
day today, so I cannot check at the Oracle Store, but
Title: Message
I'll
add one to the list:
nnn)
How much downtime and DBA time is required when the Shareplex replication queues
get corrupted and you have to rebuild your entire replicated database? (I only
add that as I've got to do it tomorrow morning).
T¬
From: Nick Wagner
[mailto
ntact an Oracle Sales Representative."
They must be upgrading :)
But for shareplex Financials issues, I think
that Financials isn't probably supported running on "shareplexed" database. You
ought to go with an Oracle solution, but I think logical standby mechanism is
currently too bug
I could access oraclestore today and didn't see neither DataGuard nor
Streams in database additions section (where RAC, Data Mining and others
are).
Then did a product search on dataguard, data guard, standby - got no
positive results...
But maybe the sales guys have other story... I've luckily
Title: SharePlex
it is _supposed_ to work that way ... close to production. But last time
we looked at it, there were too many limitations relates to IOT, VARRAYS etc and
it wasn't ready for our platform and version .
but it is supposed to be good ... I have heard similar things about
Very cute - this tends to suggest that Shareplex is
spotting the appearance of chains in the log and
storing the list of rowids.
Would the same thing work if you shut down the
Shareplex processes after the row had chained,
and restarted them before you updated the chained
piece ? And does
Title: RE: quest SharePlex
Would the same thing work if you shut down the
Shareplex processes after the row had chained,
and restarted them before you updated the chained
piece ?
-- Yes
And does Shareplex guarantee that it will
never report a 1555 error regardless of how long it
is shut
Nick,
Thanks for the notes.
I've often wondered how Shareplex
did its thing.
Just for kicks - have you tried writing
a collision handler for streams ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http
Title: RE: quest SharePlex
This is actually part of the 'magic' of SharePlex. The way we obtain the PK information from the database if the PK was not modified is very tricky.
I can tell you some of the 'magic' but not all of it. (NDA type stuff)
In all updates the redo logs contain
Hi,
I have used Shareplex for a number of years now, albeit with a
relatively simple configuration (bi-directional master-to-master
replication across a WAN). We had a few teething problems with
earlier versions of the software, but since our last upgrade about
18months ago, we have had
Title: RE: quest shareplex
Has anyone used Oracle Streams for simple A to B replication? Likes/dislikes? Can it be used in 8.1.7?
Thanx,
Alan Martin
Defense Logistics Information Service
[EMAIL PROTECTED]
-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent
with the 'supplemental logging' feature - which Shareplex
could probably use to even better effect, but how do you
do it before 9 ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html
I'm working with a couple of IBM gals(don't you all get offended) who
are asking about shareplex, i've not used it and have no idea whether
its good or not(or for that matter what its purpose is).
Anyone enlighten me.
thanks, joe
Joseph S Testa
Chief Technology Officer
Data Management
Quest Shareplex is a replication software.
Nick Wagner from Quest is on this list and he is been very helpful
and I am sure he will be glad to provide you info on it. Right Nick? :)
-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
I'm
Title: RE: quest shareplex
It allows for master to master replication. My understanding is that Oracle's Data Guard now does the same thing. Shareplex was faster then replication with less latency because it would read from the online redo files from Oracle. I understand that Data Guard now
Title: RE: quest shareplex
I was going to keep quite... but here goes. :)
-
Yes, of course I'll be glad to help.
Basically...
Log Based replication for Oracle. A capture process continually reads the online redo logs and parses out
Since the redo log contains only details about
object id, row location, and changed values , how
do you derive a table-name and key value for
the SQL to be applied ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see
ORACLE-L
I'm working with a couple of IBM gals(don't you all get offended) who
are asking about shareplex, i've not used it and have no idea whether
its good or not(or for that matter what its purpose is).
Anyone enlighten me.
thanks, joe
Joseph S Testa
Chief Technology Officer
Data Management
Title: RE: quest SharePlex
You provide a 'configuration file' which is just a flat file of table names on the source machine and table names on the target machine. Then we go through an activation process that takes the table name on the source and grabs the object id from Oracle
Hi all,
We are having a shareplex issue and I am hoping someone here with shareplex
knowledge
can help me out. I don't know much about shareplex. Basically we are
replicating to a
target table which is partitioned by date. And partitions that are 3 days
old will be set
to read-only because
Title: RE: SharePlex core dumps - help
Call Quest Software technical support. They will be more than happy to help you.
I think there is already a patch out to fix this.
Just call 1-800-306-9329 and once you speak with an operator, ask to place a support call for SharePlex.
Nick
Sounds like a bug.
If SharePlex gets an error applying SQL to the target, the table should
get marked out-of-sync and Shareplex should go on it's merry way.
Call Shareplex Support - they are usually very responsive.
- Jerry
-Original Message-
Sent: Thursday, November 07, 2002 11:35 AM
Does anyone have experience with a product called Shareplex
by Quest Software. We have some remote access performance
issues and my management is looking at this product
as a possible solution for a distributed database.
thanks,
Peter Schauss
Northrop Grumman Corporation
[EMAIL PROTECTED
Title: RE: Experience with Quest Shareplex
Hasn't Oracle basically built-in this same functionality in a current version of the RDBMS - wouldn't you want to check that out first? - Just a thought.
-Original Message-
From: Schauss, Peter [mailto:[EMAIL PROTECTED]]
Sent: Monday
Title: RE: Experience with Quest Shareplex
Last I heard about shareplex that it still had some problems with IOTs
and user defined types ... they seems to be working on those though
...
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra
I did some investigation into SharePlex a few years ago. I tried for months
to get someone to respond to email and voicemail messages to the vendor that
I want to buy SharePlex and I have the money. Eventually I got the
software for evaluation. I found once again that replication isn't easy
Title: RE: Experience with Quest Shareplex
From
indirect experience it is another layer of administration and requires some
manually steps depending on the configuration of your database/system.
Again, for that reason might want to consider Oracle's similar product that way
you won't get
Title: RE: Experience with Quest Shareplex
Unfortunately this was from vendor's sales rep.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't reflect
in the vendor vs. vendor he-said/she-said thing.
-Original Message-
Sent: Monday, October 28, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
Last I heard about shareplex that it still had some problems with IOTs and
user defined types ... they seems to be working on those though ...
Raj
operating commands and tools.
-Experience with techniques for data replication, data movement, data
loading, data warehousing, and business intelligence tools is required.
-Specific experience with Oracle Advanced Replication (OAR), Quest
Shareplex replication software, Oracle OEM and RMAN
standard reply, no aliens(foreign or outerspace kind).
joe
OraStaff wrote:
snip
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Title: RE: urgent help: replication, shareplex
I suggest you take a peek at the waits for the Shareplex process on the source system. We found that the sp_ordr processes query the source tables via the rowid mined out of the redo stream. Sp_ocap also issues queries as well as perform DML
Hi All,
I needed some help here involving shareplex.
We run two databases (an OLTP type, and a repository type) on the same E10K
domain
which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex is
being used
to replicate a table from the OLTP type to the repository. The current
recipients of list ORACLE-L (E-mail)
Subject: urgent help: replication, shareplex
Hi All,
I needed some help here involving shareplex.
We run two databases (an OLTP type, and a repository type) on the same
E10K domain
which has 8 CPUs and 8GB of RAM, using Hatachi SAN (RAID 5). Shareplex
Hello guys,
i was wondering if any of ull use Quest Shareplex for Datawarehouse ETL and/or
Reporting instance.
i am creating a data mart/reporting instance. The source database is a 7.3.4 on HP-ux
10.2
The destination(development) is 9i on Win2k. Still not figured out the platform for 9i
Title: REPLICATION: Quest Shareplex
Hi,
I changed the Subject to SHAREPLEX, lets close out the contention thread. Could be why there are no responses. A couple people on the list definitely use it and I know I certaintly will have a lot to say about it but have to do it later as I am
Hi,
I changed the Subject to SHAREPLEX, lets close out the contention thread.
Could be why there are no responses. A couple people on the list definitely use it
and I know I certaintly will have a lot to say about it but have to do it later as I
am working on Prod issues right now
I am evaluating SharePlex and I have some questions:
In the current release, do the foreign key constraints need to be disabled
in the target database? Doesn't it take a while to enable the foreign keys
during failover?
How did you handle switching the users over to the target database?
Push
1 - 100 of 133 matches
Mail list logo