Spendius wrote:
> 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.
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
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Mar 15 2006 - 11:12:12 CST
