RE: Is there a way to determine which client connects (JDBC) ?

From: Glenn Travis <Glenn.Travis_at_wcom.com>
Date: Wed, 08 Nov 2000 10:34:41 -0500
Message-Id: <10674.121421@fatcity.com>

We use WebLogic as our app server. The app server runs on coco and scully. Here is on of the queries I use; (output follows).

select USERNAME,

        OSUSER,
        machine,
        PROGRAM,
        STATUS,
        type,
        module
        from       sys.v_$session

where USERNAME is not NULL
order by USERNAME, OSUSER

USERNAME     OSUSER       MACHINE                   PROGRAM
STATUS     TYPE         MODULE
------------ ------------ ------------------------- ------------------------
------ ---------- ------------ --------------------
ESP          Ashish       ASHISH               Toad.exe
INACTIVE   USER         T?O?A?D?
ESP          ron            ES_WKSTN1        SQLPLUSW.EXE          INACTIVE
USER         SQL*Plus
ESPADMIN     esp          scully                    java_at_scully (TNS V1-V3)
INACTIVE   USER
ESPADMIN     esp          scully                    java_at_scully (TNS V1-V3)
INACTIVE   USER
ESPADMIN     weblogic     coco                      java_at_coco (TNS V1-V3)
INACTIVE   USER
ESPADMIN     weblogic     coco                      java_at_coco (TNS V1-V3)
INACTIVE   USER
ESPADMIN     weblogic     coco                      java_at_coco (TNS V1-V3)
INACTIVE   USER
ESPADMIN     weblogic     coco                      java_at_coco (TNS V1-V3)
INACTIVE   USER
SYSTEM       oracle       hampton                   sqlplus_at_hampton (TNS
V1-V3)    ACTIVE     USER         01@ sessinfo2.sql

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ronen Levit
> Sent: Wednesday, November 08, 2000 4:35 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Is there a way to determine which client connects (JDBC) ?
>
>
> When the application server (in my case weblogic) using connection pool to
> connect the db, it leaves no signs of
> which machine connected to the db. Is there a way to find out the machine
> from which the jdbc connection was made?
>
> All the info I've got from such connection is
> OSUSER = jdbcuser
> COMMAND = unknown
> MACHINE = jdbcclient
> PROGRAM = JDBC-1.0-Client
>
> Thnx,
>
> Ronen Levit
> Database team leader
> www.talmai.com
> T: +972 8 9460606 #212
> F: +972 8 9460705
> C: +972 52 448699
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ronen Levit
> INET: ronen.levit_at_talmai.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed Nov 08 2000 - 09:34:41 CST