Home » RDBMS Server » Server Administration » from where does V$Parameter get data from? (WinXP and Oracle 9i)
icon5.gif  from where does V$Parameter get data from? [message #352086] Mon, 06 October 2008 01:06 Go to next message
osama202
Messages: 6
Registered: October 2008
Location: Jordan
Junior Member

hi,
i created a spfile from pfile, but when i open the spfile using wordpad, i cant see all the parameters configured for the instance.
and when i start the database in NOMOUNT stage, and query the v$parameter or V$SPPARAMETER dynamic views it shows all the parameters including the parameters not shown in the spfile.
the question is that where are the other parameters stored? and from where are these views getting the data from in nomount stage?

Osama
Re: from where does V$Parameter get data from? [message #352117 is a reply to message #352086] Mon, 06 October 2008 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Some parameters have default value either hard coded or calculated from other values.

Check v$parameter.isdefault or v$spparameter.isspecified columns.

Regards
Michel
Re: from where does V$Parameter get data from? [message #352168 is a reply to message #352086] Mon, 06 October 2008 07:53 Go to previous messageGo to next message
osama202
Messages: 6
Registered: October 2008
Location: Jordan
Junior Member

thank you for your reply,
but the problem is, that when the database is in nomount stage,
and we query the v$spparameter view, it shows us data, keeping in mind that it cant read from the control file nor from the datafiles in the nomount stage, so from where is the data coming from?
and if it is reading from the parameters defined in the spfile, how come its reading parameter values that are not listed in the spfile?

kind regards

Osama
Re: from where does V$Parameter get data from? [message #352173 is a reply to message #352168] Mon, 06 October 2008 08:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Some parameters have default value either hard coded or calculated from other values.

What don't you understand in this answer?

Regards
Michel
Re: from where does V$Parameter get data from? [message #352343 is a reply to message #352086] Tue, 07 October 2008 03:50 Go to previous messageGo to next message
osama202
Messages: 6
Registered: October 2008
Location: Jordan
Junior Member

i understood wht u wrote,,,
just wanted to confirm from u,
u said that the parameters r hard coded, what i want to know is hard coded where? in a file a view or a table??
Re: from where does V$Parameter get data from? [message #352359 is a reply to message #352343] Tue, 07 October 2008 05:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
hard-coded means hardlt written in code. constants in code.

Regards
Michel
Re: from where does V$Parameter get data from? [message #352361 is a reply to message #352086] Tue, 07 October 2008 05:54 Go to previous messageGo to next message
osama202
Messages: 6
Registered: October 2008
Location: Jordan
Junior Member

THANX FOR U HELP
Re: from where does V$Parameter get data from? [message #353095 is a reply to message #352086] Sat, 11 October 2008 05:56 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

but when i open the spfile using wordpad
If you want to check parameter file then create pfile from spfile and open pfile instead of spfile.

otherwise your spfile will corrupted and you can't able to use it.
Previous Topic: what is the unit time in oracle??
Next Topic: oracle10g rel 2
Goto Forum:
  


Current Time: Fri Dec 09 13:52:50 CST 2016

Total time taken to generate the page: 0.17595 seconds