dbmstat

[salvareztur]

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.

[Orca777]

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