from where does V$Parameter get data from? [message #352086] |
Mon, 06 October 2008 01:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #352168 is a reply to message #352086] |
Mon, 06 October 2008 07:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|
|
|