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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 25 May 2003 20:50:52 +0800
Message-ID: <3ED0BC2C.67D1_at_yahoo.com>


Richard Foote wrote:
>
> "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

True, but it does not populate index_stats :-(

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"
Received on Sun May 25 2003 - 14:50:52 CEST

Original text of this message