Oracle PL/SQL/System Tables Views/V Parameter

List database parameters

   <source lang="sql">
 

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>

 </source>
   
  

Query parameter for

   <source lang="sql">
 

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>

 </source>
   
  

Query V$PARAMETER for current parameter settings.

   <source lang="sql">
 

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>

 </source>
   
  

Query v$parameter for database name

   <source lang="sql">
 

SQL> select value a,sysdate c from v$parameter where name = "db_name"; A

---

C

---

XE 26-OCT-09

SQL> SQL>

 </source>
   
  

select Name, Value, IsDefault from V$PARAMETER

   <source lang="sql">
 

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>

 </source>