Xref: alice comp.databases.oracle.server:83163 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.mathworks.com!cam-news-hub1.bbnplanet.com!cpk-news-hub1.bbnplanet.com!news.gtei.net!news1.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail Sender: stark@HSE-Montreal-ppp33976.qc.sympatico.ca Newsgroups: comp.databases.oracle.server Subject: Re: How to Lock an Index References: <3898A124.4A4C992B@sempra.com> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Message-ID: <87vh479dja.fsf@HSE-Montreal-ppp33976.qc.sympatico.ca> Lines: 17 User-Agent: Gnus/5.070095 (Pterodactyl Gnus v0.95) Emacs/20.5 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Thu, 03 Feb 2000 03:21:37 GMT X-Trace: news20.bellglobal.com 949548097 216.209.192.133 (Wed, 02 Feb 2000 22:21:37 EST) NNTP-Posting-Date: Wed, 02 Feb 2000 22:21:37 EST Ted Persky 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