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>;