How to check whether a database has used a PFILE or an SPFILE?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
How to check whether a database has used a PFILE or an SPFILE?
Rating:
A database user will run the following SQL query to check whether a PFILE or an SPFILE has been used by the database:
FROM sys.v WHERE name = 'spfile';
Alternatively, a database user can use the V view to check if the database has used a PFILE or not. If the "value" column is found NULL for all parameters, then the database has used a PFILE.
Rating:
Was this information helpful?