PFILE and SPFILE [message #288677] |
Tue, 18 December 2007 05:12  |
Muddassar
Messages: 28 Registered: March 2007
|
Junior Member |
|
|
I am using Oracle 9i, the database being installed in a Solaris Server.
I have looked into the pfile and the spfile in the location '/oracle/ora92/OraHome92/dbs' (thats the location of the pfile and spfile for me). I find that each of the parameter in the pfile is preceeded by a .*. For example:
*.db_block_size=4096
I have learnt that this happens when one created pfile from an spfile. So, i came to the conclusion that my pfile must have been created from an spfile. Am i right?
Also, looking into the spfile (using a textpad), i find a lot of incomprehensible characters, which is understandable as an spfile is a binary file. But, apart from those incomprehensible characters, i also see a number of parameters that were mentioned in the pfile and they are also preceeded with a .* . I am not able to understand this. Please help!
|
|
|
Re: PFILE and SPFILE [message #288678 is a reply to message #288677] |
Tue, 18 December 2007 05:15  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: | I have learnt that this happens when one created pfile from an spfile.
|
I don't know where you learn but this is wrong in the meaning you're thinking (if there is * then it is created from pfile).
Quote: | looking into the spfile (using a textpad), i find a lot of incomprehensible characters,
| *
spfile is a BINARY file not a text one.
you don't have to read or less to modify it with textpad or vi.
Regards
Michel
|
|
|