Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Locks during CREATE MVIEW without building it

Locks during CREATE MVIEW without building it

From: Spendius <spendius_at_muchomail.com>
Date: 15 Mar 2006 05:45:09 -0800
Message-ID: <1142430309.655873.129520@p10g2000cwp.googlegroups.com>


Hi,
In 8.1.7.4, we've been experiencing very annoying locks that completely

block many sessions, every time we try to define a mat. view that performs
a join against 4 tables. In V$LOCK suddenly lots of sessions appear (the
session that's performing the CREATE MVIEW especially shows a lock against OBJ$) and we're told the users' applications hang. We can't understand why. I've run utllockt.sql during the attempts to create this
mview, but no rows are yielded, only many locks appear at one blow in V$LOCK, but they do not seem related to the SID trying to create this mview... What's going on ? I've found *nothing* on Metalink or in the manuals on Tahiti that precisely describe the locks types used...

Thanks. Received on Wed Mar 15 2006 - 07:45:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US