Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Get hostname of Oracle Server from within SQLPlus
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
![]() |
![]() |