Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

246 views
Skip to first unread message

SAP BASIS Consultant

unread,
May 22, 2003, 8:57:02 PM5/22/03
to
Hello,

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

Thanks,
DF

Sathish Balas

unread,
May 22, 2003, 9:53:54 PM5/22/03
to

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

Mladen Gogala

unread,
May 25, 2003, 3:18:13 AM5/25/03
to

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

unread,
May 25, 2003, 5:23:27 AM5/25/03
to
On Thu, 22 May 2003 17:57:02 -0700, SAP BASIS Consultant wrote:

The 'analyze index validate structure' command needs a current

Richard Foote

unread,
May 25, 2003, 7:43:15 AM5/25/03
to
"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

unread,
May 25, 2003, 8:50:52 AM5/25/03
to

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

unread,
May 25, 2003, 9:49:01 AM5/25/03
to
"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 new messages