Monthly Archives: November 2017

alter session set nls_date_format=’dd-mon-yyyy hh24:mi’; SELECT usn, state, undoblockstotal “Total”, undoblocksdone “Done”, undoblockstotal-undoblocksdone “ToDo”, DECODE(cputime,0,’unknown’,SYSDATE+(((undoblockstotal-undoblocksdone) / (undoblocksdone / cputime)) / 86400)) “Finish at” FROM v$fast_start_transactions; This happens when you bounce the DB while a long running rollback is occuring. SMON … Continue reading →