Re: Oracle server name in SQL prompt

From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 29 Sep 1999 23:38:59 GMT
Message-ID: <7su7uj$91s@gap.cco.caltech.edu>

How about this:

select host_name from v$instance;

---

"Robert" Xuequn Xu, Oracle DBA
Caltech, Pasadena, CA 91125

---

Winnie Liu (winnie_liu_at_infonet.com) wrote:
: I get it in a kind of dump way. I do a query on V$sesion and find out the
: column "machine" in which one of the bg process like 'smon' is running on.

: I know.. this method does not work on parallel server!

: Winnie Liu
: DBA
: Infonet Services Corporation
: mailto:winnie_liu_at_infonet.com

: Michael Morley wrote in message ...
: >Anybody know how to put the name of the host server into the SQLPROMPT
: >SQLPlus parameter? I can get the instance name but not the server name.
: >
: >Thanks.
: >
: >Mike M
: >
: >
Received on Wed Sep 29 1999 - 18:38:59 CDT