判断一个死事务的恢复进度

declare
    l_start number;
    l_end  number;
begin
    select ktuxesiz into l_start from x$ktuxe where ktuxeusn=10 and ktuxeslt=39;
    dbms_lock.sleep(60);
    select ktuxesiz into l_end from x$ktuxe where ktuxeusn=10 and ktuxeslt=39;
    dbms_output.put_line('time est Day:'||round(l_end/(l_start-l_end)/60/24,2));
end;
/