-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|