Wanted to find out if there any database parameters that can be changed dynamically using spfile but
I have 11.2.0.2.Wanted to find out if
there any database parameters that can be changed dynamically using
spfile but have ISSYS_MODIFIABLE=FALSE in v$parameter.
The reason for my question is that we are being suggested to use spfile because according to some people we can change more init parameters dynamically when using spfile as compared to pfile.
there are two questions:
1. List of database parameters that can be changed dynamically using spfile but have ISSYS_MODIFIABLE=FALSE in v$parameter
2. Is it true that using spfile we can change more init parameters compared to pfile (please answer question #2 with a yes or no)
The reason for my question is that we are being suggested to use spfile because according to some people we can change more init parameters dynamically when using spfile as compared to pfile.
there are two questions:
1. List of database parameters that can be changed dynamically using spfile but have ISSYS_MODIFIABLE=FALSE in v$parameter
2. Is it true that using spfile we can change more init parameters compared to pfile (please answer question #2 with a yes or no)
0