OraFAQ Forum: Performance Tuning » will effect the performace of DML on Fast refresh of Materialized view

Home » RDBMS Server » Performance Tuning » will effect the performace of DML on Fast refresh of Materialized view (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

will effect the performace of DML on Fast refresh of Materialized view [message #476668]

Fri, 24 September 2010 08:07

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

Hi,

Will it effect on the performance of DML (Insert/Update/Delete) on Fast refresh of Materialized view with commit?

Thanks,

Report message to a moderator

Re: will effect the performace of DML on Fast refresh of Materialized view [message #476671 is a reply to message #476668]

Fri, 24 September 2010 08:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Will it effect on the performance of DML (Insert/Update/Delete) on Fast refresh of Materialized view with commit?
yes

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: will effect the performace of DML on Fast refresh of Materialized view [message #476673 is a reply to message #476668]

Fri, 24 September 2010 08:19

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

will it lock the master/base tables during refresh?

Report message to a moderator

Re: will effect the performace of DML on Fast refresh of Materialized view [message #476674 is a reply to message #476673]

Fri, 24 September 2010 08:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>will it lock the master/base tables during refresh?
It depends upon DML issued

Report message to a moderator

Re: will effect the performace of DML on Fast refresh of Materialized view [message #476675 is a reply to message #476674]

Fri, 24 September 2010 08:29

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

Hi BlackSwan,

Thanks for your answer...

Actually my materialized view contains a join query from 3 base tables. and each table contains 5,00000 Records.

while refreshing in complete mode it takes 30 minutes. so my question is, once I started refreshing materialized view. will it allow to insert/update/delete on base tables?

Thanks,

Report message to a moderator

Re: will effect the performace of DML on Fast refresh of Materialized view [message #476677 is a reply to message #476675]

Fri, 24 September 2010 08:30

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

Don't you think you'd get the answer to that question faster if you just try it?

Report message to a moderator

Previous Topic:	queary taking time
Next Topic:	"Fast refresh" MV too slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 20 17:27:36 CST 2025