Home » Server Options » Replication » Overhead of materialized view log on DML
Overhead of materialized view log on DML [message #403296] Thu, 14 May 2009 12:04 Go to next message
mayur316
Messages: 4
Registered: April 2009
Junior Member
Hi
Can any one tell how much would be overhead of materialized view logs against DML on tables with few millions of records?

I need to convince my team lead before moving ahead with materialized view for few reports about overhead so is there any documentation by oracle on this issue?
Re: Overhead of materialized view log on DML [message #403303 is a reply to message #403296] Thu, 14 May 2009 12:43 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As it depends on your workload and environment, you have to make benchmarks on your site.
Basically, it is one or two inserts more per modified row.

Regards
Michel
Previous Topic: Oracle migration
Next Topic: Table Replication
Goto Forum:
  


Current Time: Fri Dec 09 09:21:24 CST 2016

Total time taken to generate the page: 0.05999 seconds