select STATE,UNDOBLOCKSDONE,PID,XID from v$fast_start_servers;
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
select usn,state,undoblockstotal "Total",undoblocksdone "Done",undoblockstotal-undoblocksdone "Todo",
decode(cputime,0,'unknown',sysdate+(((undoblockstotal-undoblocksdone)/(UNDOBLOCKSDONE/cputime))/86400)) "EStime" from v$fast_start_transactions
where state <>'RECOVERED';
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
select usn,state,undoblockstotal "Total",undoblocksdone "Done",undoblockstotal-undoblocksdone "Todo",
decode(cputime,0,'unknown',sysdate+(((undoblockstotal-undoblocksdone)/(UNDOBLOCKSDONE/cputime))/86400)) "EStime" from v$fast_start_transactions
where state <>'RECOVERED';