Re: Are Enqueue locks implemented with a FIFO queuing mechanism

From: Stefano Cislaghi <>
Date: Wed, 27 Apr 2011 22:10:46 +0200
Message-ID: <>

Hello Matt,

this is an interesting problem. Have you already checked on metalink? There's an interesting doc: Performance Degradation and JI Lock Contention Observed During Batch Load of Tables With On-Commit Materialized Views [ID 371869.1]

Could be interesting. Is your matview with refresh on commit? AFAIK enqueues operate on a FIFO basis


-- Received on Wed Apr 27 2011 - 15:10:46 CDT

Original text of this message