Server hostname from SQL*Plus?

From: Michael Wilson <mwilson_at_ti.com>
Date: 1997/05/28
Message-ID: <5mhh88$6fm@sf18.dseg.ti.com>#1/1

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)

---

Received on Wed May 28 1997 - 00:00:00 CDT