I execute this sentence in sqlplus
NULL, FALSE,'FOR ALL INDEXES',NULL,'PARTITION');
If I make a this select from other session of sqlplus
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 06:34 AM.
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