determine if flashback query is enabled on your system : parameter « System Tables Views « Oracle PL / SQL






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

determine if flashback query is enabled on your system

 
SQL>
SQL> select value from v$parameter where name = 'undo_management';
VALUE
------------------------------------------------------------------------------------------------------------------------------------------------------
AUTO

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.--Query v$parameter table for 'optimizer_mode'
2.Obtain retention parm
3.show parameters block
4.show parameter type and value from v$parameter