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');
Printable View
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');
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.
Here is a good article on this subject. ;)
.