Check changed parameter in Spfile of Oracle database
Find the list of non default parameter in Oracle
set pages 100 lines 100
col name format a30
col value format a50
select name, value
from v$parameter
where isdefault = 'FALSE'
and value is not null
order by name;
NAME VALUE
-------------------------- --------------
enable_ddl_logging TRUE
enable_pluggable_database TRUE
fal_server TESTDR
fixed_date NONE
job_queue_processes 0
nls_territory AMERICA
open_cursors 500
Check the list of parameter is default or non default parameter:
select name, value, isdefault from v$parameter order by name;