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: 68625
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: Thu Mar 28 14:07:43 CDT 2024