| initialization parameter doubt [message #160959] |
Wed, 01 March 2006 03:17  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Hi all,
How can we know whether certain parameters can be modifiable
using ALTER SYSTEM cmd.
,
But when i am saying
> select * from v$parameter;
i am getting some output as follows
ISSES_MODIFIABLE ISSYS_MODIFIABLE
---------------- --------------
TRUE IMMEDIATE
FALSE IMMEDIATE
FALSE FALSE
BY seeing the above sample output can anyone tell what
parameters can be modified using alter system cmd.
Thank Q in advance.
|
|
|
|
| Re: initialization parameter doubt [message #160965 is a reply to message #160959] |
Wed, 01 March 2006 03:37  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
|
The columns isses_modifiable and issys_modifiable can be used to determine if a parameter can be changed at session level using alter session or at system level using alter system. A parameter is modifiable at session level if isses_modifiable = 'TRUE'. A parameter is modifiable at system level if issys_modifiable = 'DEFERRED' or issys_modifiable = 'IMMEDIATE'. However, if a parameter is changed at system level if issys_modifiable = 'DEFERRED' it only affects sessions that are started after chaning the parameter. Additionally, the alter system set ... deferred option must be used.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
