Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MV refresh and background jobs for index rebuild

0 views
Skip to first unread message

pratap....@gmail.com

unread,
Jan 28, 2008, 5:02:23 PM1/28/08
to
Hi,

Database Oracle - 10.2

I have a MV that is partitioned and has local indexes. The MV is
refreshed as Complete with atomic_refresh = false. This is how Oracle
is refreshing the MV -

1. Makes indexes unsuable
2. Truncates the MV
3. Insert append into the MV
4. Submits a background job to rebuild the indexes
5. Rebuild each index partition in parallel

Now the last piece is giving me a problem, as the index partitions are
rebuild in parallel, it is eating up server resources, how can I stop
Oracle from doing the rebuilds in parallel?

Regards,
Pratap

0 new messages