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