$ORACLE_HOME/dbs is the location that Oracle will use to retrieve the pfile during startup unless otherwise explicitly specified
(i.e. startup pfile=/path1/path..n/mypfile.ora)
As for the current parameters in effect for this startup of the database, refer to the v$parameter view.




Reply With Quote