Members   Search   Help    Register    Login   Home
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: 28996
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: Mon Nov 9 04:26:00 CST 2009

Total time taken to generate the page: 1.32668 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.