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 -> Re: How to Lock an Index

Re: How to Lock an Index

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 03 Feb 2000 06:48:10 GMT
Message-ID: <38992478.1121398@news.demon.nl>


On Thu, 03 Feb 2000 03:21:37 GMT, Greg Stark <greg-spare-1_at_mit.edu> wrote:

>
>Ted Persky <TPersky_at_sempra.com> writes:
>
>> When I tried to do an "alter index" to increase MAXEXTENTS by ten, it
>> returned an ORA-00054 error, that the index was busy and that I had issued
>> the command with NOWAIT.
>
>I have a related question. I've gotten the same situation and usually I'm able
>to just repeatedly try the alter command until it works. But it worries me
>since my application doesn't do any LOCK TABLEs or any large updates. Does
>this indicate I probably have some update or insert statement that is doing a
>full table lock instead of a row lock? If so how do I detect and work around
>this problem?
>
>
>--
>greg

No,
as soon as you use a table it will be locked for DDL-operations. This is a dictionary lock, it is not a table lock, AFAIK.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Feb 03 2000 - 00:48:10 CST

Original text of this message

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