Re: Does 'Analyze Index <IndexName> Validate Structure' Lock for DML Operations?

Home -> Community -> Usenet -> c.d.o.server -> Re: Does 'Analyze Index <IndexName> Validate Structure' Lock for DML Operations?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 25 May 2003 21:43:15 +1000
Message-ID: <VJ1Aa.42525$1s1.585077@newsfeeds.bigpond.com>

"Mladen Gogala" <mgogala_at_adelphia.net> wrote in message news:pan.2003.05.25.07.17.54.66541_at_adelphia.net...
> On Thu, 22 May 2003 17:57:02 -0700, SAP BASIS Consultant wrote:
>
> > Hello,
> >
> > Does the 'Analyze Index Valdiate Structure' lock the table for inserts,
> > updates and deletes in Oracle v8.1.6?
>
> The 'analyze index validate structure' command needs a current
> structure which is not being modified as the command is running.
> The only way to achieve that is to put a shared lock on the table.
> Shared locks usually do prevent transaction locks and, thus, any DML
> on the table.
>

Hi Mladen

In 8.1.6, an Analyze Index Validate Structure command did indeed lock all DML operations....

With 9i, the command has been improved and the "online" permits DML.

Cheers

Richard Received on Sun May 25 2003 - 06:43:15 CDT