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;

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply