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