database 如何检查 Oracle 实例是使用 pfile 还是 spfile 启动的？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12031587/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-08 08:40:48 来源:igfitidea点击:
How to check whether Oracle instance is started using pfile or spfile?
提问by Jay
IS there a view where i can check whether an instance had been started using a pfile or an spfile?
是否有视图可以检查实例是否已使用 pfile 或 spfile 启动？
回答by AnBisw
This shows database was started by spfile
这表明数据库是由 spfile
SQL> show parameter spfile;
NAME TYPE VALUE
---- ---- ----------------------------------------------------------
spfile string /root/apps/oracle/10g/dbs/spfile<DB_NAME>.ora
No values returned means that its started by pfile.
没有返回值意味着它由pfile.
回答by Megha Kashinkunti
SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_$parameter WHERE name = 'spfile';
