Home » RDBMS Server » Server Administration » Spfile
Spfile [message #220008] Sat, 17 February 2007 10:14 Go to next message
Upperm
Messages: 95
Registered: July 2003
Member
hello folks,
since I got in connection with ORACLE, I have been wondering about the reason why the SPFILE was made?

Can you guess why dear folks?
Thank you

[Updated on: Sat, 17 February 2007 10:15]

Report message to a moderator

Re: Spfile [message #220009 is a reply to message #220008] Sat, 17 February 2007 10:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm#1012628
icon6.gif  Re: Spfile [message #220010 is a reply to message #220008] Sat, 17 February 2007 10:47 Go to previous messageGo to next message
Bhupinder1
Messages: 2
Registered: September 2006
Location: New Delhi
Junior Member

Hii buddy, even i am new to ORacle, but wht i have understood till now is that SP file is created so that if we have started up the database with the SP file and not from the Pfile then if we make any changes in the dynamic parameters, they can take affect without shutting down and restarting the database.. While if we have started the database with P file, then on changing the parameters, for them to take affect, we have to shutdown and then restart the database which is not always easy to do in realtime applications...
Re: Spfile [message #220011 is a reply to message #220010] Sat, 17 February 2007 10:54 Go to previous message
Upperm
Messages: 95
Registered: July 2003
Member
Thanks for replying.
I should say that I do not ignore the role played by a spfile.
And I know what you said.

But why then some parameters can not be changed while the instance is running (see columns issys_modifiable of the view v$parameter) ?

Previous Topic: flash drop in 10g
Next Topic: question on index
Goto Forum:
  


Current Time: Tue Dec 06 12:26:37 CST 2016

Total time taken to generate the page: 0.23894 seconds