Find oracle_home via sqlplus

Find oracle_home via sqlplus

 

  

Howdy:

I have a machine where there are three instances running (oracle 9.0.1
and two 9.2.x).

I'm looking for the $ORACLE_HOME for each - I found them by hunting down
a few files, but is there a way to connect to an instance and find the
home directory
via sqlplus?

Thanks!

-X

Oracle LazyDBA home page