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

How to Login to SQLPLUS
Check Oracle Database in Read/Write Mode
Get the List of Oracle Ports Component
ORA-00376: file 2 cannot be read at this time
© 2017 ITsiti. All Rights Reserved
Powered by KEEM