Re: Server hostname from SQL*Plus?

Michael Wilson <mwilson_at_ti.com> wrote:
: Is there any SQL select statement that would return the hostname of the server
: that Oracle is running on? We have created links to other instances on other
: systems and it would be nice to have such a statement. GLOBAL_NAME gives you
: the link name and V$VERSION provides Oracle version info, but no hostname.
 

: Thanks,
: Michael
 

: ==============================================================
: Michael Wilson _/_/_/_/_/ _/_/_/
: SG Software Solutions _/ _/
: Defense Systems & Electronics _/ _/
: Texas Instruments, Inc. _/ _/
: _/ _/_/_/
: mwilson_at_ti.com ** 972-575-3448 ** 972-575-2628 (fax)
: ==============================================================

-- 

Hi,

you could try:

select machine from v$session where program like '%PMON%';

Rgds
Steinar Heggelund

----------------------------------------------------------------------------
I'm employed in the Norwegian consulting company Opus One AS. 
I have 7 years experience with Oracle products, mainly the database. 
We are a small company which offers consulting services in design,
implementation and tuning of databases and applications based on Oracle.

My postings represent my opinions and they may be wrong.