help!!! pfiles sfiles

[dcampo]

Hi...

I'm sorry if write very bad the english.

I'm studing Oracle and I'm looking the concept, content, what are...!! the files PFILE and SFILE in Oracle....

thanks

 

[LKBrwnDBA]

Both are equivalent, the pfile is the database initialization parameter file in text format and the spfile (server parameter file) is the same file but used by the Oracle database at run time.

The difference is that once the spfile is created it allows some permanent parameter changes without having to re-start the database; on the other hand, changes to the pfile may require restarting the database.

You can create one from the other:

CREATE SPFILE FROM PFILE;
-- or --
CREATE PFILE FROM SPFILE;





----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[KenCunningham]

You can also force the database to start using the pfile if that is necessary:

startup pfile='/path/to/pfile'

Useful if something screws up in the spfile (as if!!).

I don't mind people who aren't what they seem. I just wish they'd make their mind up.