Mapping extproc processes to Oracle sessions

From: Leng Kaing <Leng.Kaing_at_hsntech.com>
Date: Fri, 24 Jun 2005 16:40:11 +1000
Message-ID: <18D551B1B928FF47A65B2D91F705906A017BAAE7@HSNDON-EX01.hsntech.int>

Hello everyone,

I know that this is probably a really silly question but I need to know...

How do we map an extproc process to an Oracle session and see what it's doing?

We have 2 databases running on our Unix (Solaris 8) box. There were about 30 extproc sessions running this morning, some with start time of last month. They appear to be rogue processes but I cannot positively identify them as such. Do extproc sessions show up in the database?

TIA, Leng.

Leng Kaing

Hansen Technologies

2 Frederick St; Doncaster VIC 3108

Tel: +61-3-9840-3832

Fax: +61-3-9840-3102

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 24 2005 - 02:45:53 CDT