How to find whether spfile is being used or not
1 view
Skip to first unread message
sampath
Dec 12, 2008, 5:12:21 AM12/12/08
to Ask Oracle DBA
To check whether spfile is being used or not
At SQL prompt execute the following command
SQL> SHOW PARAMETER SPFILE
NAME TYPE
VALUE
------------------------------
------------------------------------ ---------------------------------
spfile string
If the value column displays NULL then the instance is started with
pfile else instance was started with spfile.
At SQL prompt execute the following command
SQL> SHOW PARAMETER SPFILE
NAME TYPE
VALUE
------------------------------
------------------------------------ ---------------------------------
spfile string
If the value column displays NULL then the instance is started with
pfile else instance was started with spfile.
Reply all
Reply to author
Forward
0 new messages