Shulou(Shulou.com)05/31 Report--

Editor to share with you how to judge ORACLE startup using spfile or pfile, I believe that most people do not know much, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

The default initialization file used when starting after Oracle 9i is spfile. We can determine whether the database is started in SPFILE or PFILE mode in the following three ways. 2. Show parameter pfile starts the database with spfile: NAME TYPE VALUEspfile string C:\ ORACLE\ PRODUCT\ 10.2.0\ DB_1\ SQL > show parameter spfile -DATABASE\ SPFILEWWL.ORASQL > startup pfile=c:\ initwwl.oraTotal System Global Area 1610612736 bytesVariable Size 385878368 bytesRedo Buffers 14708736 bytesDatabase opened.SQL > show parameter pfile -SQL > show parameter spfile -SQL > start the database using spfile We can see that the result of the query is that spfile- starts the database using pfile, and we can see that the result of the query is pfile. DECODE (COUNTpfile

The above is all the contents of the article "how to judge whether ORACLE uses spfile or pfile when starting up". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.