Home » RDBMS Server » Server Administration » Host Name
Host Name [message #57357] Mon, 09 June 2003 01:18 Go to next message
Chandru
Messages: 12
Registered: July 2000
Junior Member
Hello Folks,

We have multiple instances of Oracle 8i running on different Windows 2000 Servers in our development environment. Is there any table in the database that I can query to find out the network name of the Host on which the instance (that I am currently connected to ) is running?

Thanks in advance
Chandru

Report message to a moderator

Re: Host Name [message #57361 is a reply to message #57357] Mon, 09 June 2003 04:02 Go to previous message
psmyth
Messages: 81
Registered: October 2002
Member
select * from v$instance;

Report message to a moderator

Previous Topic: How to find Active Tables in a Database
Next Topic: ORA-12540 TNS:Internal Limit Restriction Exceeded
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:18:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.