| about initialization parameter file [message #541514] |
Tue, 31 January 2012 18:32  |
 |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
