Oracle PL/SQL/System Tables Views/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>

Query parameter for

  

SQL> select name, value from v$parameter where name="user_dump_dest";

NAME
------------------------------------------------------
VALUE
------------------------------------------------------
user_dump_dest
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
1 row selected.
SQL>
SQL>

Query V$PARAMETER for current parameter settings.

  

SQL>
SQL> select Name,
  2         Value
  3    from V$PARAMETER
  4   where Name = "log_buffer";

NAME
------------------------------------------------------
VALUE
------------------------------------------------------
log_buffer
2859008
1 row selected.
SQL>
SQL>

Query v$parameter for database name

  
SQL> select value a,sysdate c from v$parameter where name = "db_name";
A
--------------------------------------------------------------------------------
C
---------
XE
26-OCT-09

SQL>
SQL>

select Name, Value, IsDefault from V$PARAMETER

  

SQL>
SQL> select Name, Value, IsDefault
  2    from V$PARAMETER
  3    where rownum < 20;
                                                              
NAME
--------------------------------------------------------------------------------
VALUE
------------------------------------------------------------------------------------------------------------------------
ISDEFAULT
---------
tracefile_identifier
TRUE
lock_name_space
TRUE
processes
40
TRUE
sessions
49
FALSE
timed_statistics
TRUE
TRUE
timed_os_statistics
0
TRUE
resource_limit
TRUE
FALSE
license_max_sessions
0
TRUE
license_sessions_warning
0
TRUE
cpu_count
1
TRUE
instance_groups
TRUE
event
TRUE
sga_max_size
285212672
TRUE
pre_page_sga
FALSE
TRUE
shared_memory_address
0
TRUE
hi_shared_memory_address
0
TRUE
use_indirect_data_buffers
FALSE
TRUE
lock_sga
FALSE
TRUE
shared_pool_size
0
TRUE
                   
SQL>
SQL>