Identify PID for remote database handle

From: catharine_drozdowski@xxxxxxxxxx (Catharine Drozdowski)
Date: Mon, 22 May 2006 15:07:12 -0700

How can I find the server pid for a sqlplus session which is logged on
remotely inside a perl program... I can find the local PID using $$ or
$PID, but how can I find the pid for the statement/database handle which
is actually logged onto the database doing the work...

Env: Oracle, Solaris

Catharine Drozdowski
Mentor Graphics Corporation
IT Systems Services
1 503 685 7906

Follow-Ups:
- Re: Identify PID for remote database handle
  - From: Chris Sarnowski

Prev by Date: Uploaded DBIx::Log4perl to CPAN
Next by Date: Where are the selected rows stored using fetchall_arrayref
Previous by thread: Uploaded DBIx::Log4perl to CPAN
Next by thread: Re: Identify PID for remote database handle
Index(es):
- Date
- Thread

Relevant Pages

Re: pid from startet process
... perl script and need to know the childs pid. ... but the pid i am getting is not right. ... And the shell executes the command. ... that it can execute internally. ...
(comp.lang.perl.misc)
Re: pid from startet process
... perl script and need to know the childs pid. ... but the pid i am getting is not right. ... That shell then creates a new process to ... execute the command named in the $cmd parameter. ...
(comp.lang.perl.misc)
PID=0 and other newbie questions
... I am a newbie Linux user trying to run a pet server to learn more about the ... Is PID 0 even legal? ... it should be easy to do a Perl daemon that checks for PID of zero ... I hacked together a script that cleans logs after they reach a certain size, ...
(comp.os.linux.security)
Re: Wait for background processes to complete
... have the perl program wait for the commands to complete. ... Fork doesn't ... the shell exits. ... of the process, but - if it's the pid of the shell process, then we're ...
(comp.lang.perl.misc)
Re: Shell Commands (Getting PID and Timing Them)
... >>> In Perl I know how to fork and get a PID, and I know how to use ... >>> command from Perl and get the PID so I can kill it when I want. ... > BASH command from Perl, and get the PID of the BASH command. ...
(comp.lang.perl.misc)