Re: Are Enqueue locks implemented with a FIFO queuing mechanism
- From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
- To: mccmx@xxxxxxxxxxx
- Date: Wed, 27 Apr 2011 22:10:46 +0200
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
Stefano
--
http://www.stefanocislaghi.eu
--
//www.freelists.org/webpage/oracle-l
Other related posts:
