RE: Are Enqueue locks implemented with a FIFO queuing mechanism

  • From: Matt McClernon <mccmx@xxxxxxxxxxx>
  • To: <s.cislaghi@xxxxxxxxx>
  • Date: Wed, 11 May 2011 04:56:40 +0000

> 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]

Yes, I've seen that document, thanks

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

yes, they are refresh on commit                                           

Other related posts: