Não é mais possível fazer postagens ou usar assinaturas novas da Usenet nos Grupos do Google. O conteúdo histórico continua disponível.
Dismiss

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

238 visualizações
Pular para a primeira mensagem não lida

SAP BASIS Consultant

não lida,
22 de mai. de 2003, 20:57:0222/05/2003
para
Hello,

Does the 'Analyze Index Valdiate Structure' lock the table for inserts,
updates and deletes in Oracle v8.1.6?

Thanks,
DF

Sathish Balas

não lida,
22 de mai. de 2003, 21:53:5422/05/2003
para

yes it will block inserts / updates / deletes to the table .

Mladen Gogala

não lida,
25 de mai. de 2003, 03:18:1325/05/2003
para

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.

--
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds

Mladen Gogala

não lida,
25 de mai. de 2003, 05:23:2725/05/2003
para
On Thu, 22 May 2003 17:57:02 -0700, SAP BASIS Consultant wrote:

The 'analyze index validate structure' command needs a current

Richard Foote

não lida,
25 de mai. de 2003, 07:43:1525/05/2003
para
"Mladen Gogala" <mgo...@adelphia.net> wrote in message
news:pan.2003.05.25...@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


Connor McDonald

não lida,
25 de mai. de 2003, 08:50:5225/05/2003
para

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"

Richard Foote

não lida,
25 de mai. de 2003, 09:49:0125/05/2003
para
"Connor McDonald" <connor_...@yahoo.com> wrote in message
news:3ED0BC...@yahoo.com...

> >
> > 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 :-(
> --

Hi Connor,

Picky picky ;)

Richard


0 nova mensagem