Locks during CREATE MVIEW without building it

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