如何查看当前的oracle启动的是spfile还是pfile
连接到:Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string ?/dbs/spfile@.ora
SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string ?/dbs/spfile@.ora
SQL> create file pfile from spfile;
create file pfile from spfile
*
第 1 行出现错误:
ORA-00901: invalid CREATE command
SQL> create pfile from spfile;
文件已创建。
SQL> SQL> select decode(count(isspecified), 1, 'SPFILE', 'PFILE')
2 from v$spparameter
3 where isspecified = 'TRUE'
4 and rownum = 1 ;
DECODE(COUNT
------------
SPFILE
页:
[1]