|
-
DBMS_STATS is new introduced in 8i onwards and before that analyze command was used(gather_database statistics is one of the package for dbms_stats). Both are used for cost based optimizer to gather system statistics to optimize your queries. To answer your question, YES it is used for performance tuning purpose, but you can use it too to find information like no of blocks/rows/high water mark etc used by any system/user objects.
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
|