Slow refresh mview

From: bob123 <nomail_at_nowhere.com>
Date: Tue, 21 Dec 2010 14:22:26 +0100
Message-ID: <4d10aa12$0$1588$426a74cc_at_news.free.fr>

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 Received on Tue Dec 21 2010 - 07:22:26 CST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]