joe_echavarria
asked on
Pfile and SPfile - Oracle
Hi,
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 ?
Regards,
Joe.
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 ?
Regards,
Joe.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
c) unless you specify the location on the start command itself.
d) it can be outside of the default location if the DBA wants it to be.
f) it also shows current values for your session.
For example:
show parameter nls_date_format
That is the current format for your session.
If you: alter session set nls_date_format='MM-DD-YYY
You will see that format and not the one in the pfile/spfile.