Check maximum query duration in Oracle for undo retention setting
Check the maximum query duration in Oracle:
SQL> select max(maxquerylen) from v$UNDOSTAT;
SQL> select max(maxquerylen) from DBA_HIST_UNDOSTAT;
Set the undo retention to Max value:
SQL> alter system set UNDO_RETENTION=<value in sec>;