-
stats on X$ tables
Hi,
Once we gather stats on oracle dictionary, How can we tell if stats were indeed collected on all the dictionary objects.
I have report from SAP that says some of the X$ tables DO NOT have stats on them though we have gathered stats on oracle dictionary.
v$fixed_table does not have 'last_analyzed' column. I'm not sure how to check that. Also, are there any x$ tables that should not have stats on them?
Appreciate your help.
Jay
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
|