Re: Determing Server IP or Host name from within Oracle

Bob,

You could try:

select host_name from v$instance;

-- 
Regards,

Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com

Sauron wrote:


> 

> Here is poser I have been working on for several days and no clear

> resolution.

> 

> I have two servers configured the same, (drives, folder structure, etc).

> One is my current production server,  the other is my soon-to-be new

> production server.

> 

> My "want" is to be able to do a SQL query that returns me the IP or hostname

> of the current server I am on.  BTW, the instance is the same on both

> machines.  I know that I can tell by looking at my v$sga since I made the

> sga bigger on the new server.  But, is there another way?

> 

> Thanks

> Bob