Re: Linking IP address to Oracle process
From: MARREEL Chris <MARREEL_CHRIS/BENG_at_bekaert.com>
Date: 1996/11/07
Message-ID: <328259C1.32E4_at_bekaert.com>#1/1
Date: 1996/11/07
Message-ID: <328259C1.32E4_at_bekaert.com>#1/1
Andy Finkenstadt wrote:
>
> >> We have had a similar problem - using SQL*Net to connect to Oracle, how can
> >> we tell which session belongs to which user (given that our app is
> >> designed to connect to Oracle with a common Oracle userid).
>
> Using "lsof -i" check for all processes that have connections to
> the local orasrv port. The remote host name will be the machine
> connected to your local oracle database.
>
> Next cross-check the local process number with the process number
> recorded in the v$session & v$process views.
>
> Andy
> --
> Andrew Finkenstadt, The Printing House Ltd, Also a GEnie Sysop
>
Greetings
Chris MARREEL.
-- ======================================================================== BEKAERT ENGINEERING Tel : 32 / 51 / 333 515 Meulebekestraat 139 Fax : 32 / 51 / 333 472 8770 - INGELMUSTER -----------\ West-Vlaanderen (BELGIUM) /------\ | | | / | Name : MARREEL Chris | |----\ | Function : System Administrator | | | | Compuserve : 106101,1624 | \----/ | \\|// INTERNET Email: MARREEL_CHRIS/BENG_at_bekaert.com \--------/ (o o) ==========================================================oOOo=(_)=oOOo=Received on Thu Nov 07 1996 - 00:00:00 CET