Re: Question regarding replication

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Mon, 01 Feb 1999 12:19:53 -0800
Message-ID: <36B60C69.D6F96DD7@us.oracle.com>

Hannah

Whether the replication will work from a performance perspective is really a suck it and see scenario in my experience. My gut feeling with the data volumes you're talking about are to run it more often than once a day. Yes, you would be better off with Oracle8 from a performance perspective. Throughputs under Oracle7 max'ed at about 10-15 tps, with Oracle8 you can get 20-100 tps (this is very dependent on your application, so don't take these figures as gospel).

The other thing to be careful of in an OPS environment is that the replication doesn't cause too much pinging.

HTH Pete

hchrist wrote:

> Hello,
>
> I have a customer, who is using Oracle Version 7.3 Parallel Server on a
> Cluster System. I would like to replicate the database to an additional
> cluster. Users are allowed to query data on that additional cluster. Their
> access is read only. The data doesn't have to be real time for now. This
> might change in the future. The size of the database is 500 Gigabyte. The
> amount of data that is added/changed is about 15-20 Gigabyte per day. Since
> my experience with Oracle is limited, I would like to know:
>
> 1) Is setting up a single master with one read-only snapshot site that is
> updated once per day a good solution in the above scenario? Are there any
> known problems? (The network is fast enough: A dedicated link with 100 Mb)
> 2) Are there better alternatives?
> 3) Should I upgrade to Version 8.0?
> 4) Would the above scenario still work, if the data has to be updated on an
> hourly basis on the additional cluster?
>
> Thanks,
>
> Hannah

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon Feb 01 1999 - 14:19:53 CST