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_at_yahoo.com> 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_at_yahoo.com
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 05 2005 - 07:58:39 CDT
