Re: Identify PID for remote database handle--CLARIFICATION...

There's some sys DBMS packages that you can have the perl program call and update the MODULE, ACTION, etc columns to make it easier to identify your program if needed. I'm not a my work desk nor do I aim to memorize these things so I cannot be specific. Generally you see perl.exe though at least in my env. As thomas states, v$process and v$session have what you need.


Thomas Hilbig wrote:
Isn't that exactly what Chris Sarnowski's suggested
SQL does? If you want the OS PID on the database
server process (running the DML under Oracle) that is
serving your client (Perl/DBI),

select vp.spid from v$process vp, v$session vs where
vs.sid = (select sid from v$mystat where rownum = 1)
and vp.addr = vs.paddr

If you want to see all server processes for all
clients (not what you asked for, but good for
testing):
select vp.spid from v$process vp, v$session vs where
vp.addr = vs.paddr

Tom

--- "Drozdowski, Catharine"
<catharine_drozdowski@xxxxxxxxxx> wrote:

Yep, you got it...

PS I did send Ron/Chris separate email to make
nice....

-----Original Message-----
From: JupiterHost.Net
[mailto:mlists@xxxxxxxxxxxxxxx] Sent: Tuesday, May 23, 2006 10:12 AM
To: dbi-users@xxxxxxxx
Subject: Re: Identify PID for remote database
handle--CLARIFICATION...



Reidy, Ron wrote:

No, I do not know you are a DBA; maybe YOU cannot
describe the problem

well enough.

-----Original Message-----
From: Drozdowski, Catharine
[mailto:catharine_drozdowski@xxxxxxxxxx]
Sent: Tuesday, May 23, 2006 10:11 AM
To: Reidy, Ron; dbi-users@xxxxxxxx
Subject: RE: Identify PID for remote database
handle--CLARIFICATION...
You know I AM a DBA and will withdraw the post as
you guys seem to not

be able to grasp the concept.
Ok kids ne nice :)

The question is (assuming I understand it)

Is there a way to get or have DBI set so it can be
gotten the PID of the
$dbh process ont he DB server (local or remote)

Correct?



__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

---------------------------------------------------------------------------------------------------
Text inserted by Platinum 2006:

This message has NOT been classified as spam. If it is unsolicited mail (spam), click on the following link to reclassify it: http://127.0.0.1:6083/Panda?ID=pav_146&SPAM=true
---------------------------------------------------------------------------------------------------




.

Relevant Pages
Quantcast