Identified which Parameters been Modified after Oracle Instance Startup



Share this article :

You can execute below command to get the list of modified parameters after the Oracle instance startup.

SQL> select name from v$parameter where ISMODIFIED='MODIFIED';

NAME
--------------------------------------------------------------------------------
nls_language
nls_territory
nls_sort
nls_date_language

The ISMODIFIED from V$PARAMETER indicates whether the parameter has been modified after instance startup:

• MODIFIED – Parameter has been modified with ALTER SESSION

• SYSTEM_MOD – Parameter has been modified with ALTER SYSTEM (which causes all the currently logged in sessions’ values to be modified)

• FALSE – Parameter has not been modified after instance startup

Related posts

Oracle Database Server Structures
V$INSTANCE: Display Oracle Database & Instance State
Find Parameter in Oracle
Certain files which need to be reinstalled by Oracle UI are being used
© 2018 ITsiti. All Rights Reserved
Powered by KEEM