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.