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

17:30:37 SQL> select distinct KTUXECFL,count(*) from x$ktuxe group by KTUXECFL;
KTUXECFL                  COUNT(*)
------------------------ ----------
DEAD                              1
NONE                          2393
                  SCO|COL                          8

16:59:47 SQL> select ADDR,KTUXEUSN,KTUXESLT,KTUXESQN,KTUXESIZ 
            2 from x$ktuxe where  KTUXEUSN=10 and KTUXESLT=39;
ADDR              KTUXEUSN  KTUXESLT  KTUXESQN  KTUXESIZ
---------------- ---------- ---------- ---------- ----------
FFFFFFFF7D07B91C        10        39    2567412    1086075
17:02:12 SQL> select ADDR,KTUXEUSN,KTUXESLT,KTUXESQN,KTUXESIZ 
            2 from x$ktuxe where  KTUXEUSN=10 and KTUXESLT=39;
ADDR              KTUXEUSN  KTUXESLT  KTUXESQN  KTUXESIZ
---------------- ---------- ---------- ---------- ----------
FFFFFFFF7D07B91C        10        39    2567412    1086067
                  

17:08:28 SQL> declare
17:10:22  2  l_start number;
17:10:22  3  l_end    number;
17:10:22  4  begin
17:10:22  5    select ktuxesiz into l_start from x$ktuxe where  KTUXEUSN=10 and 
KTUXESLT=39;
17:10:22  6    dbms_lock.sleep(60);
17:10:22  7    select ktuxesiz into l_end from x$ktuxe where  KTUXEUSN=10 and 
KTUXESLT=39;
17:10:22  8    dbms_output.put_line('time est Day:'|| round(l_end/(l_start 
-l_end)/60/24,2));
17:10:22  9  end;
17:10:22  10  /
time est Day:2.55