Re: Row-X (SX) lock on materialized view
Date: Sat, 13 Jun 2009 11:53:59 +0200
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
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.
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Sat Jun 13 2009 - 04:53:59 CDT