| Calculate hit on performance when using replication? [message #75197] |
Fri, 21 June 2002 08:05  |
David Adams
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hey all:
We are looking at using replication on an online system (.com transaction-based) to provide a user-reporting database copy. would likely update it hourly. Has anyone had any experience with how much this effects on-line performance, or, how much hardware is needed to cover the hit?
thanks!
dave
|
|
|
|
| Re: Calculate hit on performance when using replication? [message #75218 is a reply to message #75197] |
Sun, 21 July 2002 17:44  |
David Simpson
Messages: 29
Registered: May 2002
|
Junior Member |
|
|
There is quite a bit of redo generated by Oracle's Advanced Replication because the data ends up being written in queue tables at each server before being propagated or applied. During the Oracle Advanced Replication class at Oracle we were given the quideline of a maximum of 200 - 400 transactions per second for Advanced Replication.
The great news is that with Oracle 9.2, a new feature called Streams Replication is able to take the redo from archivelog files and read/apply the appropriate data to the selected tables on the destination servers. This should cut the redo activity in half - though I have not tried it yet.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
