Thursday, October 19, 2017

How do you know if you are using spfile or pfile

This shows database was started by spfile
SQL> show parameter spfile;

NAME    TYPE    VALUE
----    ----   ----------------------------------------------------------
spfile  string /root/apps/oracle/10g/dbs/spfile<DB_NAME>.ora
No values returned means its started by pfile

No comments:

Post a Comment