DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: stats on X$ tables

  1. #1
    Join Date
    Feb 2001
    Posts
    129

    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

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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...

    Regards,

    Chiappa

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