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

Yep, you got it...

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

-----Original Message-----
From: JupiterHost.Net [mailto:mlists@jupiterhost.net]=20
Sent: Tuesday, May 23, 2006 10:12 AM
To: dbi-users@perl.org
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.
>=20
> -----Original Message-----
> From: Drozdowski, Catharine [mailto:catharine_drozdowski@mentor.com]
> Sent: Tuesday, May 23, 2006 10:11 AM
> To: Reidy, Ron; dbi-users@perl.org
> Subject: RE: Identify PID for remote database handle--CLARIFICATION...
>=20
> 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?

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

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"
wrote:

> Yep, you got it...
>
> PS I did send Ron/Chris separate email to make
> nice....
>
> -----Original Message-----
> From: JupiterHost.Net
> [mailto:mlists@jupiterhost.net]
> Sent: Tuesday, May 23, 2006 10:12 AM
> To: dbi-users@perl.org
> 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@mentor.com]
> > Sent: Tuesday, May 23, 2006 10:11 AM
> > To: Reidy, Ron; dbi-users@perl.org
> > 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

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"
> wrote:
>
>
>> Yep, you got it...
>>
>> PS I did send Ron/Chris separate email to make
>> nice....
>>
>> -----Original Message-----
>> From: JupiterHost.Net
>> [mailto:mlists@jupiterhost.net]
>> Sent: Tuesday, May 23, 2006 10:12 AM
>> To: dbi-users@perl.org
>> 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@mentor.com]
>>
>>> Sent: Tuesday, May 23, 2006 10:11 AM
>>> To: Reidy, Ron; dbi-users@perl.org
>>> 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
> ------------------------------------------------------------ ---------------------------------------
>
>
>