Re: Distributed database setup

Jean-Marc Prevost wrote:
>
> Hi,
>
> We are looking at linking multiple Oracle databases (Oracle 8i)
> throught database link in different cities. Geometry data (Oracle
> Spatial Object model) and regular data will be exchange between
> databases. The number of users is not confirmed yet.
>
> Of course we would like something that respond as fast as possible
> (who don't!) for emergency situation. Is there a rule of thumb that
> says for that amount of users you this bandwith, this sort of thing to
> reduce latency, this...? (I was told that Net8 is chatty. Is there a
> work around?)
>
> I know this is vague but some hints would be helpful!
>
> Thanks

Net8 Chatty?
Appletalk is chatty.
You can disable Server-side checking to see if the client connection is dead by setting the parameter

SQLNET.EXPIRE_TIME=0 in the file sqlnet.ora.

Use bulk collection features to reduce the number of small packets. Its up to your developers to take advantage of these features.

Read as much as you can on (advanced) replication. I've been told, that if the application has not been designed with replication in mind - chances are good that the deployment will fail.

If you're deploying read-only partioned data with transportable tablespaces from a single master, you might have the bulk of the traffic reduced.

Here's a start:
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76960/toc.htm http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76959/toc.htm

good luck.

Paul Received on Tue Aug 28 2001 - 01:37:30 CDT