DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: analyze

  1. #1
    Join Date
    Mar 2001
    Posts
    287
    What are the difference between
    i) Analyze
    ii) DBMS_UTILITY.ANALYZE_DATABASE
    iii) DBMS_STATS.GATHER_DATABASE_STATS
    ?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    same

    but I wouldnt use DBMS_UTILITY.ANALYZE_DATABASE, it had a bug in Oracle 8, it analyzes sys objects as well

    You cannot use a single ANALYZE command to analyze the whole database

    With DBMS_STATS.GATHER_DATABASE_STATS you can

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    My understanding is DBMS_STATS.GATHER_DATABASE_STATS
    also analyzes SYS objects. Is it a bug too?

    Sanjay

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by SANJAY_G
    My understanding is DBMS_STATS.GATHER_DATABASE_STATS
    also analyzes SYS objects. Is it a bug too?

    Sanjay
    Yes, this is bug 1422285. It is fixed in Oracle 9.0



  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    didnt know that since I never analyze the whole database ina go

    kewl

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