spfile and pfile
|
spfile |
pfile |
|
spfile is a binary file |
pfile is a text file |
|
User can’t edit |
User can edit |
|
Automatically load when don’t specify pfile
Eg,
sqlplus> startup mount; |
Need to specify the file
Eg.
Sqlplus>startup mount file=[PATH]/pfilename.ora |
|
To create spfile
sqlplus>create spfile from pfile |
To create pfile
sqlplus>create pfile from spfile |
|
Changes effects dynamically |
To effect changes need to restart |
If you need to change the spfile parameter settings use following steps
Sqlplus> create pfile from spfile;
Pfile will create in defalt path (ORACLE_HOME/dbs/) .
Edit pfile and save.
Sqlplus> create spfile from pfile;
