Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>