OraFAQ Forum: Server Administration » from where does V$Parameter get data from?

Home » RDBMS Server » Server Administration » from where does V$Parameter get data from? (WinXP and Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

from where does V$Parameter get data from? [message #352086]

Mon, 06 October 2008 01:06

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

Report message to a moderator

Re: from where does V$Parameter get data from? [message #352117 is a reply to message #352086]

Mon, 06 October 2008 04:05

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: from where does V$Parameter get data from? [message #352168 is a reply to message #352086]

Mon, 06 October 2008 07:53

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

Report message to a moderator

Re: from where does V$Parameter get data from? [message #352173 is a reply to message #352168]

Mon, 06 October 2008 08:33

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: from where does V$Parameter get data from? [message #352343 is a reply to message #352086]

Tue, 07 October 2008 03:50

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??

Report message to a moderator

Re: from where does V$Parameter get data from? [message #352359 is a reply to message #352343]

Tue, 07 October 2008 05:37

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

hard-coded means hardlt written in code. constants in code.

Regards
Michel

Report message to a moderator

Re: from where does V$Parameter get data from? [message #352361 is a reply to message #352086]

Tue, 07 October 2008 05:54

osama202
Messages: 6
Registered: October 2008
Location: Jordan

Junior Member

THANX FOR U HELP

Report message to a moderator

Re: from where does V$Parameter get data from? [message #353095 is a reply to message #352086]

Sat, 11 October 2008 05:56

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.

Report message to a moderator

Previous Topic:	what is the unit time in oracle??
Next Topic:	oracle10g rel 2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 07 23:34:56 CDT 2024