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>
|