OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Spfile

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Spfile [message #220008]

Sat, 17 February 2007 10:14

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

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm#1012628

Report message to a moderator

Re: Spfile [message #220010 is a reply to message #220008]

Sat, 17 February 2007 10:47

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...

Report message to a moderator

Re: Spfile [message #220011 is a reply to message #220010]

Sat, 17 February 2007 10:54

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) ?

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:38:08 CDT 2024