Locks during CREATE MVIEW without building it

[Spendius]

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.

[DA Morgan]

Given that Oracle 8i is Neolithic and in desupport I'd recommend that
you focus your attentions on moving to a version that will both solve
the problem and enhance your resume. Might I suggest you get to 10.2
before 11 is released?
--
Daniel A. Morgan
http://www.psoug.org
damo...@x.washington.edu
(replace x with u to respond)

[Spendius]

How about WAITING until it is, so that it'll spare
me the time to have to learn everything about 9i/10g
new features and stuff ?

DA Morgan a écrit:

[Sybrand Bakker]

On 16 Mar 2006 03:46:03 -0800, "Spendius" <spen...@muchomail.com>
wrote:

>How about WAITING until it is, so that it'll spare
>me the time to have to learn everything about 9i/10g
>new features and stuff ?

Bad idea. Surely Oracle will release a new version before you manage
to do that. Apart from that: you need to improve your general Oracle
knowledge, so the version is irrelevant and you'd better go for the
most recent version, if at all possible.

--
Sybrand Bakker, Senior Oracle DBA

[Keith]

I've used both 8.1.7 and 10.2; It may be EASIER to learn the new
features of 10.2 oracle than to make do with 8.1.7 ...