Re: enq: MS - contention when selecting from base tbl during refresh
From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Tue, 10 Jul 2012 21:21:19 +0100
Message-ID: <CAPMSPxNXViz6G_CcO6cUzX2jY-vRQ=hnrUL2wrwn3YVRYk_7TQ_at_mail.gmail.com>
Hi,
This really does sound like a bug, where a query is waiting to decide if it should use the MV or not.
Have you tested with different query_rewrite_integrity settings?
Date: Tue, 10 Jul 2012 21:21:19 +0100
Message-ID: <CAPMSPxNXViz6G_CcO6cUzX2jY-vRQ=hnrUL2wrwn3YVRYk_7TQ_at_mail.gmail.com>
Hi,
This really does sound like a bug, where a query is waiting to decide if it should use the MV or not.
Have you tested with different query_rewrite_integrity settings?
Regards
Pete
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 10 2012 - 15:21:19 CDT