What are the difference between
i) Analyze
ii) DBMS_UTILITY.ANALYZE_DATABASE
iii) DBMS_STATS.GATHER_DATABASE_STATS
?
Printable View
What are the difference between
i) Analyze
ii) DBMS_UTILITY.ANALYZE_DATABASE
iii) DBMS_STATS.GATHER_DATABASE_STATS
?
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
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.0Quote:
Originally posted by SANJAY_G
My understanding is DBMS_STATS.GATHER_DATABASE_STATS
also analyzes SYS objects. Is it a bug too?
Sanjay
didnt know that since I never analyze the whole database ina go
kewl