PfileVSSpfile（MOSNote249664.1） - 数据库编程

oduct/920/dbs/racdb_init.ora'
FROM SPFILE='/u01/oracle/product/dbs/racdb_spfile.ora';

Refer to 'Oracle 9i Database Reference' for all the parameters that can be changed with an ALTER SYSTEM command...

IS MY DATABASE USING SPFILE ?

=============================

Am I using spfile or pfile ?

The following query will let you know..

1) SQL> SELECT name,value FROM v parameterWHEREname= ′ spfile ′ ;NAMeva lUE????????????????????????????????????????????????????????????spfile/fsys1/oracle/product/9.2.0/spfileTEST.ora2)SQL>showparameterspfile;Thev spparameter view
The contents of the SPFILE can be obtained from the V$SPPARAMETER view: 修改后的静态参数，重启数据库前可以从这个视图里面查到修改后的值

SQL> ALTER SYSTEM SET timed_statistics=FALSE SCOPE=SPFILE;
System altered.

SQL> SELECT name,value FROM v$parameter WHERE name='timed_statistics';

NAME VALUE
-------------------- ---------------------
timed_statistics TRUE

SQL> SELECT name,value FROM v$spparameter WHERE name='timed_statistics';

NAME VALUE
-------------------- ---------------------
timed_statistics FALSE


RELATED DOCUMENTS
-----------------

Oracle 9, Oracle 10g

PfileVSSpfile（MOSNote249664.1）(三)