Obtain retention parm : parameter « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. parameter

Obtain retention parm

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

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.--Query v$parameter table for 'optimizer_mode'
2.determine if flashback query is enabled on your system
3.show parameters block
4.show parameter type and value from v$parameter