Oracle database log mode

Select log_mode from v$database;