Re: Slow refresh mview
From: Adrian <bulleid_at_ffoil.org.uk>
Date: Tue, 21 Dec 2010 19:49:34 +0000
Message-ID: <WKNCXBEOTQENFwM3_at_nospam.demon.co.uk>
In message <4d10aa12$0$1588$426a74cc_at_news.free.fr>, bob123 <nomail_at_nowhere.com> writes
>Hi,
>
>I have some Mviews for query rewrite it takes 15-20 minutes to create
>them
>The refresh takes more than 5 hours ...
>
>why ?
>What can I do to speed this ?
>
>Oracle 9.2.0.7
>
>Thanks in advance
>
>
Date: Tue, 21 Dec 2010 19:49:34 +0000
Message-ID: <WKNCXBEOTQENFwM3_at_nospam.demon.co.uk>
In message <4d10aa12$0$1588$426a74cc_at_news.free.fr>, bob123 <nomail_at_nowhere.com> writes
>Hi,
>
>I have some Mviews for query rewrite it takes 15-20 minutes to create
>them
>The refresh takes more than 5 hours ...
>
>why ?
>What can I do to speed this ?
>
>Oracle 9.2.0.7
>
>Thanks in advance
>
>
Do you have materialized view logs on the underlying tables ?, what sort of refresh are you doing (fast or complete) ?
Adrian
-- To Reply : replace "bulleid" with "adrian" - all mail to bulleid is rejected Sorry for the rigmarole, If I want spam, I'll go to the shops Every time someone says "I don't believe in trolls", another one dies.Received on Tue Dec 21 2010 - 13:49:34 CST