Find the Location of Oracle SPFILE

Share this article :

Login to the SQL*PLUS and execute below query command,

SQL> show parameter spfile

NAME         TYPE        VALUE
------------ ----------- ------------------------------
spfile       string      /oracle/SID/112_64/dbs/spfileSID.ora

Related posts

Oracle Database Server Structures
Specifying SCOPE in Parameter for BOTH, Memory & SPFILE
ORA-00955: name is already used by an existing object
© 2017 ITsiti. All Rights Reserved
Powered by KEEM