Re: enq: MS - contention when selecting from base tbl during refresh

  • From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Jul 2012 21:21:19 +0100

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: