On / Off

select flashback_on from v$database;

Documentation / Reference

• Researching and Reversing Erroneous Table Changes - Oracle® Database Administrator's Guide 12c Release 1 (12.1)