Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Get hostname of Oracle Server from within SQLPlus

Re: Get hostname of Oracle Server from within SQLPlus

From: Ronald <devnull_at_ronr.nl>
Date: 30 Jul 2001 09:49:55 -0700
Message-ID: <67ce88e7.0107300849.3b405966@posting.google.com>

lmcstmc_at_lmc.ericsson.se (steve) wrote in message news:<bdd5c887.0107300621.7fae68d5_at_posting.google.com>...
> Hi,
>
> Is there a SQL command I can issue from within SQLPlus
> that will return the hostname of the Oracle Server I
> am currently connected to (assuming it is a remote server).
>
> Something along the lines of 'select name from v$database;'

Hi Steve

several ways: machine from v$session of pmon process or host_name from v$instance.

Ronald.
http://ronr.nl/unix-dba Received on Mon Jul 30 2001 - 11:49:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US