方法一:
SQL> select name,value from v$parameter where name='spfile';
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
spfile
/oracle/product/10.2.0/dbs/spfiledg1.ora
方法二
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/product/10.2.0/dbs/spf
iledg1.ora
方法三:(备注:如果返回为O,说明正在使用PFILE)
SQL> select count(*) from v$spparameter where value is not null;
COUNT(*)
----------
15
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8334342/viewspace-448476/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8334342/viewspace-448476/