In oracle database there is couple
of way to find out whether database is running with spfile or pfile.
 |
| Parameter File |
1.
SQL>show parameter spfile;
After executing above returns blank
then database was started using pfile.
2.
SQL>select name,value from
v$parameter where name=’spfile’;
If database running with spfile , it
will return the result.
If
database running by pfile , we can create the spfile from pfile.
No comments:
Post a Comment
Thanks for reading till end. I hope this will help you more to improve your knowledge.
Now it's your turn!
What do you think? Share your experience in the comments box and subscribe for more interesting post.