Search V$PARAMETER for a parameter : V_PARAMETER « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. V_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>