Home » RDBMS Server » Server Administration » name of view
name of view [message #51220] Tue, 07 May 2002 22:05 Go to next message
siva kumar
Messages: 6
Registered: April 2002
Junior Member
Hello,
I need a small information.In which view can I get the host name where the oracle DB is available.
For ex if I am having DB yyyy in host xxxxxxxx,so in which view can I get this information.
Please help me in getting this information.

Thanks & Regards
Siva

Report message to a moderator

Re: name of view [message #51223 is a reply to message #51220] Wed, 08 May 2002 01:56 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
check the view V$session..

EX: select machine from v$session;

This would solve your problem...

Saai

Report message to a moderator

Previous Topic: Error Starting Service
Next Topic: instance, database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 09:41:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.