Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Determing Server IP or Host name from within Oracle

Determing Server IP or Host name from within Oracle

From: Sauron <bobmel_at_bellsouth.net>
Date: Tue, 21 Nov 2000 04:43:08 GMT
Message-ID: <w3nS5.15730$n9.1080173@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 Mon Nov 20 2000 - 22:43:08 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US