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?

Report message to a moderator

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: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 07 14:17:02 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.