about initialization parameter file [message #541514] |
Tue, 31 January 2012 18:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9262c085e52166ed765c54f5daedeb9e?s=64&d=mm&r=g) |
justlearner
Messages: 9 Registered: January 2012
|
Junior Member |
|
|
Hi All,I have a question about spfile.
SQL> SELECT COUNT(*) FROM v$parameter WHERE value IS NOT NULL;
COUNT(*)
----------
246
SQL> SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL;
COUNT(*)
----------
20
v$parameter displays information about the initialization parameters that are currently in effect for the session,but v$spparameter displays information about the contents of the spfile.
I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from?
My initialization parameter file is spfile.
|
|
|
|
|
|