Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Pfile and SPfile

The location where we install the oracle software is called as Oracle Home.
The moment once we issue the “startup”(to open the database) oracle looks for Pfile or SPfile in the $ORACLE_HOME/dbs



If both Pfile and SPfile are existing, then priority goes to SPFile(which means oracle reads SPFile).
Pfile is a text file where as SPfile is partial binary and partial text in nature.
Related Posts Plugin for WordPress, Blogger...

Flag Counter