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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: network sockets & processes

Re: network sockets & processes

From: Andrew Timpo <atimpo_at_mediaone.net>
Date: Tue, 17 Oct 2000 21:36:07 -0400
Message-Id: <10652.119576@fatcity.com>


We are running a three tiered setup with a TP monitor (Tuxedo) in the middle. All the Tuxedo processes use the same userid on the Oracle side (too much work to change that - political). Once in a while we get an application developer that releases poor code that we have to track down for various reasons (it wreaks havoc on the DB side or the TP monitor side). If a process is consuming 30M of session memory I want to know who wrote it so I can instruct them on the finer points of development. :)

John Kanagaraj wrote:
>
> Hi Andrew,
>
> > Does anyone know how to take a given socket number out of netstat -a and
> > trace it back to an OS process? I'm running on an AIX 4.3 platform.
> > Thanks in advance.
>
> Does the 'netstat -a' show you an IP address also along with it? If so,
> you could write a script that resolves it to a name, match that with the
> what's available in the listener.log and match that with the LOGON_TIME
> in V$SESSION... (seems like a very round-about route!)
>
> What exactly are you hoping to achieve?
>
> John Kanagaraj
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Kanagaraj
> INET: JKanagaraj_at_mfi.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
> also send the HELP command for other information (like subscribing).
Received on Tue Oct 17 2000 - 20:36:07 CDT

Original text of this message

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