Re: LOCKING ON THE UET$ TABLE

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 11 Nov 1999 09:14:24 -0000
Message-ID: <942311862.14600.0.nnrp-07.9e984b29@news.demon.co.uk>

There is an article on my Web-site about the work that SMON does (v7, but most of it still applies to 8.1).

How many extents do you have in the large materialised view ? The more you have the longer it takes to drop an object, and the longer the ST lock (which I assume it the one you mean) is held.

This is an argument against UNLIMINTED EXTENTS, and an argument for using LOCALLY MANAGED TABLESPACES, which you now have in 8.1.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

JJ RONE wrote in message <80cva3$mb1$1_at_nnrp1.deja.com>...

>The Problem is that I have to eliminate the materialized views on the
>current database. This has not been a problem for the smaller snapshots
>(materialized views), but the larger ones seem to keep the table
>"UET$" locked with a disk Space transaction as the Lock type.
>
>I cannot find any reference to this table in the Documentation and I
>have also not encountered a 'disk space transaction' lock before to my
>knowledge.
>
Received on Thu Nov 11 1999 - 03:14:24 CST