Analyze table 1

[llmclaughlin]

After running "analyze table ALIQUOT compute statistics;" it practically took down the server, no queries would work against the table. Had to reboot server to get things to work again. Any ideas on what could cause this just by running the statement.


Thanks



Louie

 

[Dagon]

For a start, you shouldn't be using analyze. It's an out of date command (the manuals even say so). The correct thing to use is DBMS_STATS.

For Oracle-related work, contact me through Linked-In.

 

[llmclaughlin]

Ok, Thanks

Louie