查看创建索引,分析表和分析索引的进度
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';