Home » Server Options » Replication » What is the cost (Oracle, 11g, solaris)
What is the cost [message #621554] Thu, 14 August 2014 04:45 Go to next message
Messages: 100
Registered: June 2008
Location: MGL
Senior Member

I have a table on Server A which has 10 million records. Every day inserted 1K -5K records inserted that table.

1. The program read full that table on Server B via DB link from Server A every 30 minutes.

2. I create materialized view on Server B from the table of Server A then refresh every 1 minutes. The program read this materialized view on Server B.

What is the cost saving? Is there any difference the servers performance?

[Updated on: Thu, 14 August 2014 04:47]

Report message to a moderator

Re: What is the cost [message #621558 is a reply to message #621554] Thu, 14 August 2014 05:06 Go to previous message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What your tests report?

Previous Topic: (Error (-4) retrieving key) during Golden Gate Password Encryption
Next Topic: Golden Gate Replication : Error while using Column with white space (and special character)
Goto Forum:

Current Time: Thu Sep 24 11:03:31 CDT 2020