DBMS_STATS vs. ANALYZE

[sreddy]

Here is the Tom Kyte thread that talks about differences a bit with demos:

http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:735625536552,%7Banalyze%7D

[Edited by sreddy on 10-08-2002 at 10:17 AM]

[Shestakov]

I sometimes got another kind of problem.
If i try analize large tables/indexes in parallel mode
I will increase probability of ORA-01555 errors if somebody
will execute any kind of long transaction on the same set of tables or indexes.
And no matter how many and what size of rollback segments i have.
The problem is : how analize command use rollback segments internally.
But this problem still question for me.