Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

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

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

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 25 May 2003 23:49:01 +1000
Message-ID: <Pz3Aa.42618$1s1.585159@newsfeeds.bigpond.com>

"Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message news:3ED0BC2C.67D1_at_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 Received on Sun May 25 2003 - 08:49:01 CDT

This message: [ Message body ]
Next message: chan01: "AQ dequeue commit"
Previous message: Galen Boyer: "Re: URGENT Can you convert SQL Stored Proceedures to Oracle?"
In reply to: Connor McDonald: "Re: Does 'Analyze Index <IndexName> Validate Structure' Lock for DML Operations?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US