OraFAQ Forum: Server Administration » Pfile very small(2 Merged)

Home » RDBMS Server » Server Administration » Pfile very small(2 Merged) (Oracle 10G / Windows)

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

Pfile very small(2 Merged) [message #513306]

Sun, 26 June 2011 09:33

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

When creating manually a pfile from an spfile

create pfile ='mypfile.ora' from spfile;

I noticed that many parameters are missing in the generated pfile, there are just some 20 parameters instead of 250 ! where are the others ?

Can some one enlighten me ?

Thanks

Report message to a moderator

Re: pfile very small [message #513308 is a reply to message #513306]

Sun, 26 June 2011 09:44

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

This may explain:

select name,value,isspecified from v$spparameter order by 3,1;

Report message to a moderator

Re: Pfile very small [message #513310 is a reply to message #513306]

Sun, 26 June 2011 09:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can some one enlighten me ?
parameters in pfile are only those parameters with non-default values.

parameters with defaults values do not need to be specified.

Report message to a moderator

Re: Pfile very small [message #513312 is a reply to message #513310]

Sun, 26 June 2011 11:11

Karlia
Messages: 40
Registered: May 2011
Location: Algiers

Member

Great !
Thank you guys

Report message to a moderator

Previous Topic:	Version_time in v$database
Next Topic:	SPFILE problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 01:45:33 CST 2025