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: