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

Thread: Analyze or Stat

  1. #1
    Join Date
    Aug 2008
    Posts
    118

    Analyze or Stat

    What should i do to analyze all tables in Schema:

    Should i use :
    exec dbms_utility.analyze_schema('user','schema_name');(Please correct me if i am wrong on script plase)

    Or should i use Stat:

    exec dbms_stats.gather_schema_stats('schema_name');

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    I think you can use any one of the two.
    Thanks/Gopu

  3. #3
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Use Gather schema stats, taht's the recommended one.
    http://www.perf-engg.com
    A performance engineering forum

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Assuming you want to gather stats on Ora8i/Ora9i/Ora10g/Ora11g dbms_stats is your choice; dbms_utility has been made obsolete long time ago.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477

    Talking Analyze vs Dbms.Stats

    Here is a good article on this subject.
    .
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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