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

Thread: dbmstat

  1. #1
    Join Date
    Jan 2003
    Posts
    40

    dbmstat

    HI EVERYONE
    I execute this sentence in sqlplus
    EXECUTE dbms_stats.gather_table_stats(schema','table_name','partition_name',
    NULL, FALSE,'FOR ALL INDEXES',NULL,'PARTITION');
    If I make a this select from other session of sqlplus
    SELECT *
    FROM user_tab_partitions
    WHERE table_name in ('TB_MEDIDA_PF')
    AND PARTITION_NAME LIKE '%07JUN2001'
    ORDER BY TABLE_NAME,PARTITION_NAME;
    The column last_analyzed has been actualized but sqlplus don't finish.
    It can run more than one hour and finally I interrupt the process.
    Last edited by salvareztur; 02-21-2003 at 07:34 AM.

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    first oracle samples the table-data, then the index-data : 'FOR ALL INDEXES' ...
    Probably this is the reason ?
    Look in : dba_indexes where table_name = 'YOURTABLE'
    there you can see the progress of last_analyzed
    Orca

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