Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Monday 1 December 2014

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:

Post a Comment