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