Monday, July 14, 2014

Finding spfile Location from your database.

Using this query you can find your physical spfile location.

SQL> CONN /AS SYSDBA
Connected.
SQL> select value from v$parameter where name = 'spfile';

VALUE
--------------------------------------------------------------------------------
D:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBRMAN.ORA

SQL>


No comments:

Post a Comment