Re: Row-X (SX) lock on materialized view
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 13 Jun 2009 11:53:59 +0200
Message-ID: <79hba7F1qc6niU2_at_mid.individual.net>
On 04.06.2009 19:51, joel garry wrote:
Date: Sat, 13 Jun 2009 11:53:59 +0200
Message-ID: <79hba7F1qc6niU2_at_mid.individual.net>
On 04.06.2009 19:51, joel garry wrote:
> Is there a difference between how the mviews are defined? I'm
> wondering if it is something like the strange one uses on commit, or
> something.
I have only very small experience with MV's so I might be totally off mark here: Maybe an index is missing or invalid on that particular log table so Oracle has to lock the whole table.
Another option that comes to mind is foreign keys: when there is no index on the FK column then also table locks are held.
Kind regards
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Sat Jun 13 2009 - 04:53:59 CDT