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
Messages: 4
Registered: April 2009
Junior Member
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: 63911
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.

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

Current Time: Sat Oct 22 17:28:57 CDT 2016

Total time taken to generate the page: 0.07798 seconds