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

ORA-00257: archiver stuck
V$ARCHIVED_LOG: Archived Log Information from Control File
V$BACKUP_DEVICE: Display Supported Backup Devices
Set Column Size in SQLplus
© 2018 ITsiti. All Rights Reserved
Powered by KEEM