DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: DBMS_STATS vs. ANALYZE

  1. #11
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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]
    Reddy,Sam

  2. #12
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width