| Pfile or Spfile [message #166183] |
Wed, 05 April 2006 01:18  |
suryamz
Messages: 17
Registered: March 2006
|
Junior Member |
|
|
Hi
We currently are on 8i/Win NT and would be migrating to 10g.
1)For the creation of a database, ideally which one is suggested
to use - either PFILE or SPFILE ?
2)Going forward on 10g, would it be okie if we go with PFILE instead of SPFILE .
Also,
please can anyone forward me a link or white paper that signifies the latest init parameters that are includedin 10g as against 8i.
Thanks
Surya.
|
|
|
|
|
|
| Re: Pfile or Spfile [message #166484 is a reply to message #166183] |
Thu, 06 April 2006 10:10  |
oldschool
Messages: 8
Registered: August 2005
|
Junior Member |
|
|
Hi,
The big difference between SPFILE and PFILE :
If you use SPFILE, you can change dynamic parameters without restarting your instance. So it can be useful sometime in production.
Be careful to recreate your spfile from pfile when you change static parameters.
In 10g, startup database by default is on spfile.
So, for stactic parameters, change the pfile
startup like that :
startup pfile=$oracle_home/admin/ORACLE_SID/pfile...
and afterthat, update your spfile like that :
SQL> create spfile from pfile;
|
|
|
|
| Re: Pfile or Spfile [message #166489 is a reply to message #166484] |
Thu, 06 April 2006 10:42 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
@oldschool, your method would require 2 'bounces' of the Oracle server. rather than that use:
alter system set parameter = value scope = spfile;
or scope = memory
or scope = both
(default is both)
then shutdown and startup.
no need to
alter the pfile, shutdown the db, startup with pfile parameter. create the spfile, shutdown the db. startup the db.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
