Question: How to check spfile and pfile location on oracle database 18c?
Answer : By using below query you will get spfile and pfile location.
Query :
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/TESTDB/PARAMETERFILE/spfi
le.268.10677533457
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/TESTDB/PARAMETERFILE/spfi
le.268.10677533457
Answer : By using below query you will get spfile and pfile location.
Query :
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/TESTDB/PARAMETERFILE/spfi
le.268.10677533457
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/TESTDB/PARAMETERFILE/spfi
le.268.10677533457
No comments:
Post a Comment