Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Obtain retention parm

SQL> -- SQL> SQL> select value from v$parameter where name = 'undo_retention'; VALUE ------------------------------------------------------------------------------------------------------------------------------------------------------ 900 1 row selected. SQL> SQL> --