區分oracle的初始化參數為靜态還是動态

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4

V$PARAMETER

displays information about the initialization parameters that are currently in effect for the session. A new session inherits parameter values from the instance-wide values displayed by the

V$SYSTEM_PARAMETER

view.

The

ISSYS_MODIFIABLE

column in

V$PARAMETER

tells us whether the parameters are static or dynamic. Static parameters require the instance to be restarted while dynamic parameters can take effect immediately upon being changed.

SQL> select distinct issys_modifiable from v$parameter;

ISSYS_MODIFIABLE

---------------------------

DEFERRED

FALSE

IMMEDIATE

·         IMMEDIATE - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.

·         DEFERRED - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.

·         FALSE - Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26194851/viewspace-711713/，如需轉載，請注明出處，否則将追究法律責任。

轉載于:http://blog.itpub.net/26194851/viewspace-711713/