DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001

    stats on X$ tables


    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.


  2. #2
    Join Date
    Sep 2000
    Sao Paulo,SP,Brazil, Earth, Milky Way
    See, the X$ objects in truth are NOT tables, they are a bunch of arrays in memory, and the dictionary views like nn_TABLES search only for real tables, yes... So, afaik, excluding some weird and non-documented query with internal objects, the best way to check for stats in fixed tables is to use DBMS_STATS.EXPORT_FIXED_OBJECTS_STATS to export the stats to a user table and see what you see...



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.