RE: Are Enqueue locks implemented with a FIFO queuing mechanism

From: Matt McClernon <mccmx_at_hotmail.com>
Date: Wed, 11 May 2011 04:56:40 +0000
Message-ID: <COL117-W511CADC9DC316A4A63F22BB7860_at_phx.gbl>


> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 10 2011 - 23:56:40 CDT

Original text of this message