Learner - A starter to work on a Database and its Administration
Saturday, April 5, 2014
How to check if Oracle DB is started by spfile or pfile
Below is the code that can be used to check
SELECT DECODE (VALUE, NULL, 'PFILE', 'SPFILE')
"Init File Type"
FROM V$PARAMETER
WHERE NAME = 'spfile';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment