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>

Related examples in the same category

1.	Query V$PARAMETER for current parameter settings.
2.	Query v$parameter for database name
3.	Query parameter for
4.	List database parameters

select Name, Value, IsDefault from V$PARAMETER : V_Parameter « System Tables Views « Oracle PL / SQL

Related examples in the same category