Home » RDBMS Server » Server Administration » spfile
spfile [message #156242] Tue, 24 January 2006 00:13 Go to next message
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
Member
What is the difference between SPFILE and PFILE? Both of them have initialization parameters.Then Why we have to use two files ?
Re: spfile [message #156249 is a reply to message #156242] Tue, 24 January 2006 01:23 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Did you try reading the manuals?

did you search it anywhere before posting??

Read this


Warm Regards,
Tarun Dua
Re: spfile [message #156250 is a reply to message #156242] Tue, 24 January 2006 01:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm#1012628
Re: spfile [message #156259 is a reply to message #156249] Tue, 24 January 2006 03:07 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Quote:

Did you try reading the manuals?
Does he ever
Actually I think that the OP actually does read the documentation, however he/she has problems understanding certain bits. That's fair play.
The problem is that the questions that venkatraghavan asks makes it look like he/she has done absolutely no previous reading on the subject other than to have heard the term(s)

@venkatraghavan
If you can make your questions less generic and actually show that you have already put some effort in to investigating the answers to your questions for yourself, I'd bet that the answers coming from the many experts on this board would be far more detailed and explanatory than a link to the documentation. A very large percentage of your questions are answered with such links, I cannot believe that you don't now at least try to read this stuff.

Try to explain what you don't understand and why.

e.g.
'I don't understand the difference between pfile and spfile. They both look the same to me and appear to do the same thing. I have read the documentation which says:
Quote:

blah blah
but I can't see where the difference is. '

I'll guarantee you that you will get loads of people giving more than just documentation links if you post your questions in this manner.

Actually here
http://www.orafaq.com/forum/t/58027/68488/
is a great example of what I'm talking about Wink

HTH
Jim

[Updated on: Tue, 24 January 2006 03:10]

Report message to a moderator

Previous Topic: best SGA
Next Topic: change extent management LOCAL to DICTIONARY
Goto Forum:
  


Current Time: Wed Feb 19 03:35:09 CST 2025