Re: lock type of analyze
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 5 Aug 2005 20:56:40 +0800
Just to add, newer versions of Oracle have "analyze validate structure
onlne" although in the case of indexes, it doesn't appear to populate
index_stats :-(
On 8/4/05, raja rao <raja4list@xxxxxxxxx> wrote:
> HI All,
>
> Does the analyze table compute statistics (or dbms_stats) statement lock
> the table
> in anymode
>
> Thanks,
> Raj
--
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
