Undo retention time with autoextend on and autoextend off in Oracle
The undo tablespace can have many datafiles, but if it has at least 1 datafile with autoextend=on then the tablespace will use the first approach, it will set the undo retention time based on statistics of the database gathered. MMON will calculate the value of “tuned_undoretention” based on the “maxquerylen” that checks every 30 sec … Read more