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
How big is the box that is the source for this machine? Have you tried
running sp_ctrl and doing a shutdown and startup?
Allan
-Original Message-
Sent: Thursday, October 23, 2003 10:30 AM
To: Multiple recipients of list ORACLE-L
Hi gurus,
Oracle 8.1.7.3 on Sun Solaris
One of our
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
Who's using other 50%? Is SP active or is waiting?
On 10/23/2003 02:19:32 PM, [EMAIL PROTECTED] wrote:
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
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 for
Your DNS is toasty. Gethostbyname is a UNIX system call that takes your
ip address and turns it into a name. This could be a big part of your
delay. Networked apps do not take kindly to being unable to both
forward and reverse lookups. H_errno = 2 is not found.
Allan
-Original
Since the results of triggers firing in the source will appear in the
log files, then in general you do not want the same triggers firing in
the target. Similarly since data integrity is usually enforced in the
source db you can typically disable it in the target. I suppose
something on this
I probably found my problem. My replicated tables have a lot of indexs.
I removed all of them, and step by step I will add indexs who will help my
replication.
Tx
Luc
-Original Message-
Sent: October 23, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
Since the results of
Do you have primary keys etc and hint file? Also do you have constraints disabled. Some "Nelson, Allan" [EMAIL PROTECTED] wrote:
Since the results of triggers firing in the source will appear in thelog files, then in general you do not want the same triggers firing inthe target. Similarly since
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
12 matches
Mail list logo