通过查询：x$ktuxe 【[K]ernel layer [t]ransaction layer [u]ndo transaction [e]ntry】
select distinct ktuxesiz from x$ktuxe where KTUXESTA='ACTIVE';
查看恢复进度：
select * from x$ktuxe where ktuxecfl = 'DEAD' and ktuxesta = 'ACTIVE'；
恢复进度
declare
l_start number;
l_end number;
begin
select ktuxesiz into l_start from x$ktuxe where KTUXEUSN=12 and KTUXESLT=40;
dbms_lock.sleep(60);
select ktuxesiz into l_end from x$ktuxe where KTUXEUSN=12 and KTUXESLT=40;
dbms_output.put_line('time est Day:'|| round(l_end/(l_start -l_end)/60/24,2));
end;
/
l_start number;
l_end number;
begin
select ktuxesiz into l_start from x$ktuxe where KTUXEUSN=12 and KTUXESLT=40;
dbms_lock.sleep(60);
select ktuxesiz into l_end from x$ktuxe where KTUXEUSN=12 and KTUXESLT=40;
dbms_output.put_line('time est Day:'|| round(l_end/(l_start -l_end)/60/24,2));
end;
/