### sqlplus
1.SPFILE$SID.ORA
2.SPFILE.ORA
3.INIT$SID.ORA
4.INIT.ORA
SEARCH Ͽ ̽ ⵿ Ѵ.
#### ̽ SPFILE ⵿ ǰ 떄....
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string %ORACLE_HOME%\DATABASE\SPFILE%
ORACLE_SID%.ORA
SQL>
Ǵ....
SQL> select isspecified,count(value) from v$spparameter group by isspecified;
ISSPEC COUNT(VALUE)
------ ------------
FALSE 0
TRUE 31
SQL>
Ȯ Ҽ ְ VALUE TRUE SPFILE Ȯ Ҽ ִ.
#### ̽ pfile ⵿ ǰ ...
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
VALUE ƹ͵ .