Check non default parameter in Oracle database

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;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.