List database parameters : V_Parameter « System Tables Views « Oracle PL / SQL

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

List database parameters

  


SQL>
SQL>
SQL> spool db_parameters.log
SQL> select name, value
  2  from v$parameter order by name;



NAME
------------------------------------------------------
VALUE
------------------------------------------------------
O7_DICTIONARY_ACCESSIBILITY
FALSE

active_instance_count


aq_tm_processes
0

archive_lag_target
0

asm_diskgroups


asm_diskstring


asm_power_limit
1

audit_file_dest


                          Page:   2

NAME
------------------------------------------------------
VALUE
------------------------------------------------------
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP

audit_sys_operations
FALSE

audit_trail
NONE

background_core_dump
partial

background_dump_dest
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP

backup_tape_io_slaves
FALSE

bitmap_merge_area_size
1048576

blank_trimming
FALSE



257 rows selected.

SQL> spool off
SQL>

   
    
  

Related examples in the same category