Pfile and SPfile - Oracle
Posted on 2016-10-12
I have a few questions regarding Pfile and SPfile. I am a bit confuse.
a) How can i check if my database was started using spfile or pfile ?
b) How can i check if both the Pfile and SPfile has the same configuration ?
c) When starting a database using the sqlplus command "start" --- does it uses the spfile or the pfile ?
d) Where is the location of the spfile and the pfile ?
e) Does the Init file is the same as the pfile ?
f) When executing "Show Parameters " using SqlPlus , it gets the information from the Pfile or from SPfile ?