Select Se.Sid,
Opname,
Trunc(Sofar / Totalwork * 100, 2) || '%' As Pct_Work,
Elapsed_Seconds Elapsed,
Round(Elapsed_Seconds * (Totalwork - Sofar) / Sofar) Remain_Time,
Sql_Text
From V$session_Longops Sl, V$sqlarea Sa, V$session Se
Where Sl.Sql_Hash_Value = Sa.Hash_Value
And Sl.Sid = Se.Sid
And Sl.Sid = '6903'
And Sofar != Totalwork;
oracle_查询sql执行剩余时间
于 2023-05-31 11:53:01 首次发布