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>
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-lReceived on Tue May 10 2011 - 23:56:40 CDT