查看创建索引，分析表和分析索引的进度

 查看创建索引，分析表和分析索引的进度

SELECT  SID,  decode(totalwork, 0, 0, round(100 * sofar/totalwork, 2)) "Percent", message "Message", start_time, 
elapsed_seconds, time_remaining  from V$Session_longops 
--where sid = 50

select distinct t.OBJECT_NAME from v$segment_statistics t where t.OWNER='MYWORK' and T.OBJECT_TYPE = 'TABLE';