查看长时间运行的session

SELECT sid,
       decode(totalwork, 0, 0, round(100 * sofar / totalwork, 2)) "Percent",
       message "Message",
       start_time,
       elapsed_seconds,
       time_remaining,
       inst_id
  FROM gv$session_longops where sid = 910

 

rename表后对索引要重建，否则索引的哦rowid指向的是原表的位置。