Dbms_stats Package
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dbms_stats Package

  1. #1
    Join Date
    Jan 2008
    Posts
    45

    Post Dbms_stats Package

    hey guys,

    where do we see the output of dbms_stats.gather_table_stats?

    thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Thumbs down

    Did you try even looking at {ALL|DBA}_TAB_STATISTICS and {ALL|DBA}_COL_STATISTICS?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2006
    Posts
    175
    Quote Originally Posted by chaitanyagoa
    hey guys,

    where do we see the output of dbms_stats.gather_table_stats?

    thanks
    What output do you mean? Check all_tab_statistics for latest 'gather stats' for the table. Dbms_stats.gather_table_stats statement updates the dictionary with the latest changes on the table, column or indexes etc. Compare the stats before and after running the dbms_stats statement, you can see the difference in num_rows column. Also check the same column in dba/user_tables.

    HTH,
    gtcol

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