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

This entry was posted in Oracle on by .

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.