Oracle PL/SQL Tutorial/System Tables Data Dictionary/V PARAMETER

30. Search V$PARAMETER for a parameter

SQL> select Name,
  2         Value
  3    from V$PARAMETER
  4   where Name like "log_archive%";
                                                              
NAME
--------------------------------------------------------------------------------
VALUE
------------------------------------------------------------------------------------------------------------------------
log_archive_config

log_archive_start
FALSE
log_archive_dest

log_archive_duplex_dest

log_archive_dest_1

log_archive_dest_2

log_archive_dest_3

log_archive_dest_4

log_archive_dest_5

log_archive_dest_6

log_archive_dest_7

log_archive_dest_8

log_archive_dest_9

log_archive_dest_10

log_archive_dest_state_1
enable
log_archive_dest_state_2
enable
log_archive_dest_state_3
enable
log_archive_dest_state_4
enable
log_archive_dest_state_5
enable
log_archive_dest_state_6
enable
log_archive_dest_state_7
enable
log_archive_dest_state_8
enable
log_archive_dest_state_9
enable
log_archive_dest_state_10
enable
log_archive_max_processes
2
log_archive_min_succeed_dest
1
log_archive_trace
0
log_archive_local_first
TRUE
log_archive_format
ARC%S_%R.%T
                    
SQL>
SQL>
SQL>