<div>
Are you confused about PFILE vs. SPFILE, perhaps? &nbsp;The SPFILE allows certain parameters to be dynamically changed, either at a command prompt or by the instance, doing its automated tuning. &nbsp;Changes to the PFILE do not affect the currect instance. &nbsp;I can explain this further if matches your intent.<br />
<br />
Don't forget that one may search the EE site for past threads on this topic. &nbsp;Others may have already answered this.<br />
<br />
Regards,<br />
dvz<br />

</div>


Are you confused about PFILE vs. SPFILE, perhaps?  The SPFILE allows certain parameters to be dynamically changed, either at a command prompt or by the instance, doing its automated tuning.  Changes to the PFILE do not affect the currect instance.  I can explain this further if matches your intent.

Don't forget that one may search the EE site for past threads on this topic.  Others may have already answered this.

Regards,
dvz


<div>
<div class="content wysiwyg-content">
Dear Sir,<br />
I am having a confusion between init.ora file and pfile.I know whenever we give the command Startup and Shutdown to start and down the database the database read the init.ora file automatically.But if we start and shutdown the database using pfile, we have to mention the absolute location of the pfile.And I also know the we can modify the pfile.So it will be better for me if you kindly say what is the main difference between the init.ora file and pfile.<br />
Waiting for your suggession.
</div>
</div>


Dear Sir,
I am having a confusion between init.ora file and pfile.I know whenever we give the command Startup and Shutdown to start and down the database the database read the init.ora file automatically.But if we start and shutdown the database using pfile, we have to mention the absolute location of the pfile.And I also know the we can modify the pfile.So it will be better for me if you kindly say what is the main difference between the init.ora file and pfile.
Waiting for your suggession.

Difference between init.ora and pfile

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.