PFILE and SPFILE
Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. For Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora… Read More »The Default Location of SPFILE and PFILE for Linux and Windows
In my case, I plan to use SPFILE to startup the database instance which used to use a known PFILE to open. But the problem… Read More »How to Point to SPFILE in PFILE to Trick Scripts
If we need to change some values of parameters persistently, what should we start? First of all, we have to know whether the database started… Read More »Whether Database Started with SPFILE or PFILE?
Without declaring SCOPEIf you do not specify this clause, then:If a server parameter file was used to start up the database, then BOTH is the… Read More »The Default Values in "ALTER SYSTEM SET" Statement