Re: speed of light
Date: Fri, 6 Jun 2008 23:11:44 -0700 (PDT)
Message-ID: <8d1a98f5-3ee6-4c57-9079-bfae46ccd1a9@s21g2000prm.googlegroups.com>
Thanks all for the comments. Several things to follow up now.
- What is DA? I will try to find out. The DBA said on multiple (written) occasions "replicates to [machine] using DA replication". It was also called "line by line replication" by someone else.
- A 400 msec response time shouldn't be caused by the speed of light - that should only account for 100 msec and thus can't be the main problem.
- TCP/IP tuning needs investigating.
- Increase frequency of switching redo to decrease problem with Dataguard lag time.
- Can a materialized view help?
- Find out what Quest is.
Follow up question:
What is this "old scripted way of doing things" (compressing logs etc)? If Dataguard is causing us grief, we have a non-DG utility/ script already available that doesn't require messing with the application and would be a generic solution worldwide?
Extra information:
An additional problem with Dataguard is that it requires the database to be put into "receive" mode which means we can't have the application up and running (but dormant) while the database is the target of replication.
And another problem is that the tables can't be part of a larger
schema -
the database needs to be a surrogate of the master box.
BFN. Paul. Received on Sat Jun 07 2008 - 01:11:44 CDT