Check maximum query duration in Oracle

by tuanlp September 27, 2023

written by tuanlp September 27, 2023

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