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
