Re: Determing Server IP or Host name from within Oracle

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 21 Nov 2000 10:35:04 -0000
Message-ID: <8vdj4p$9ki$1@soap.pipex.net>

if you query v$session for background processes I believe that the machine name might well give you what you want..

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Sauron" <bobmel_at_bellsouth.net> wrote in message
news:w3nS5.15730$n9.1080173_at_newsread2.prod.itd.earthlink.net...


> 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

>

>

Received on Tue Nov 21 2000 - 04:35:04 CST