RE: Are Enqueue locks implemented with a FIFO queuing mechanism

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