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
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Hi,

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

What your tests report?

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 02:56:52 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.