Re: What Server am I on

On Fri, 10 Sep 1999 11:47:02 +0100, "Keith Jamieson" <jamiesonk_at_phoenix.ie> wrote:

>
>Is there anyway (say from the system catalogs, etc, I can find out which
>server the procedure is running from.
>

SQL> desc v$instance;

 Name                            Null?    Type
 ------------------------------- -------- ----
 INSTANCE_NUMBER                          NUMBER
 INSTANCE_NAME                            VARCHAR2(16)
 HOST_NAME                                VARCHAR2(64)
 VERSION                                  VARCHAR2(17)
 STARTUP_TIME                             DATE
 STATUS                                   VARCHAR2(7)
 PARALLEL                                 VARCHAR2(3)
 THREAD#                                  NUMBER
 ARCHIVER                                 VARCHAR2(7)
 LOG_SWITCH_WAIT                          VARCHAR2(11)
 LOGINS                                   VARCHAR2(10)
 SHUTDOWN_PENDING                         VARCHAR2(3)

SQL> select version,instance_name,host_name from v$instance;

VERSION INSTANCE_NAME HOST_NAME

----------------- ----------------
------------------------------------------------------
8.0.4.0.0         orc1             RDW01

This works on Oracle8 but not on oracle7.

You can also try v$database--I don't remember if this one is defined in Oracle7.
>
>
>
>
>
Received on Mon Sep 13 1999 - 21:28:01 CDT