Undo Advisor help to estimate the undo tablespace size and undo retention to avoid ORA-1555
Prepare by: Nurullah Sharif Scope: Undo Advisor Undo Advisor help to estimate the undo tablespace size and also advise of undo retention. SQL> @db NAME OPEN_MODE ——— ——————– COLLPROD READ WRITE Undo retention is 900 sec which 15 min SQL> sho parameter undo NAME TYPE VALUE ———————————— ———– —————————— undo_management string AUTO undo_retention integer 900 undo_tablespace string UNDOTBS2 […]