Home » RDBMS Server » Server Administration » about initialization parameter file (oracle 11.2.0.1, win7)
about initialization parameter file [message #541514] Tue, 31 January 2012 18:32 Go to next message
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.
Re: about initialization parameter file [message #541515 is a reply to message #541514] Tue, 31 January 2012 18:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from?
What about parameters that use default values?
Re: about initialization parameter file [message #541516 is a reply to message #541515] Tue, 31 January 2012 18:53 Go to previous messageGo to next message
justlearner
Messages: 9
Registered: January 2012
Junior Member
>What about parameters that use default values?
u mean that?
SQL> SELECT count(*) FROM v$parameter where isdefault = 'TRUE';
COUNT(*)
----------
320
Re: about initialization parameter file [message #541527 is a reply to message #541516] Tue, 31 January 2012 23:22 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, she means the opposite, not default parameter values.

Regards
Michel
Previous Topic: invalid dba_objects: do I need to care/repair?
Next Topic: ora 002236
Goto Forum:
  


Current Time: Fri Mar 29 07:41:46 CDT 2024