Check maximum query duration in Oracle

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

Related posts

How to deal with ORA-00020: maximum number of processes (%s) exceeded

How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database 

Công cụ tự động khai báo datafile – Oracle