Home » SQL & PL/SQL » SQL & PL/SQL » PFILE and SPFILE
PFILE and SPFILE [message #288677] Tue, 18 December 2007 05:12 Go to next message
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! Smile
Re: PFILE and SPFILE [message #288678 is a reply to message #288677] Tue, 18 December 2007 05:15 Go to previous message
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
Previous Topic: Table Joins
Next Topic: Order by
Goto Forum:
  


Current Time: Tue Feb 18 20:07:16 CST 2025