Wednesday, November 18, 2009

spfile in 9i, 10g and 11g

There is a quite a difference in how your ouput shows up in 9i, 10g and 11g when you do a "show parameter spfile", here is how it shows up if the instance was brought up using an spfile.




Oracle 9i

SQL> sho parameter spfile

NAME TYPE VALUE
-------------------------- ----------- ------------------------------
spfile string ?/dbs/spfile@.ora

Oracle 10g

SQL> sho parameter spfile

NAME TYPE VALUE
-------------------------- ----------- ------------------------------
spfile string /oracle/product/10.2.0/dbs/spfile10G.ora

Oracle 11g

SQL> sho parameter spfile

NAME TYPE VALUE
-------------------------- ----------- ------------------------------
spfile string /oracle/product/11.1.0/dbs/spfile11G.ora




The output in 9i does not show the full ORACLE_HOME location, neither does it display the spfile name while in 10g and above the full ORACLE_HOME location gets displayed along with the spfile name.

No comments: