LISTING 1: PARAMETER SPFILE LOCATION
SQL> show parameter spfile
NAME TYPE VALUE
--- --- ------------------
spfile string %ORACLE_HOME%\DATABASE\SPFILE%
ORACLE_SID%.ORA
| You can (but shouldn't unless you have some compelling reason to do so) change the location for the SPFILE from the default value. |
|