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:
I think you can use any one of the two.
Use Gather schema stats, taht's the recommended one.
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.
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
Click Here to Expand Forum to Full Width