ORA-1555Tag ArchiveSubscribe

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 ———————————— ———–… Continue Reading Undo Advisor help to estimate the undo tablespace size and undo retention to avoid ORA-1555