RE: Identify PID for remote database handle--CLARIFICATION...
am 23.05.2006 18:27:32 von Ron.Reidy
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]=20
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.=20
=20
-----Original Message-----
From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]=20
Sent: Tuesday, May 23, 2006 8:51 AM
To: Drozdowski, Catharine; dbi-users@perl.org
Subject: RE: Identify PID for remote database handle--CLARIFICATION...
This is somewhat off topic as it has nothing to do with DBI nor Perl.
However ...
When a connection request is made to an Oracle database instance, the
TNS listener receives this request. If the listener is configured to
create dedicated sessions, a new process is created, connected to the
database instance. This new process opens a socket (tcp) for
communicating with the client process. The listener then hands this
socket address back to the client program and returns to listening for
connection requests.
Now, to identify the PID of this new process, someone else has already
described the mechanism for getting that information from the DB. If
you want DB resource usage, you will need to look at the performance
views V$PROCESS, V$SESSION (wait events), and the ASH and AWR views in
10gR2.
If you need more information on these views, see the Oracle docs and/or
talk with your DBA.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Drozdowski, Catharine [mailto:catharine_drozdowski@mentor.com]
Sent: Tuesday, May 23, 2006 9:32 AM
To: dbi-users@perl.org
Subject: RE: Identify PID for remote database handle--CLARIFICATION...
To the DBI/DBD list:
Let me rephrase this question a bit.=20
I have a perl program running on server A which makes a remote
connection to a database running on server B using the DBI/DBD construct
of a database handle/statement handle. On server A, the perl program has
a process ID, identified by $$ or $PID.=20
On server B where the actual DDL inside the statement handle is running,
resources are being consumed by the database to construct the query
return set. That resource usage is being accounted for somehow at the OS
level on server B. My assumption is that they are assigned a PID by the
OS.... It is this process id which I would like to capture.
I hope this clarifies what I am looking for ...
Thanks,
catharine
-----Original Message-----
From: Chris Sarnowski [mailto:csarnows@pcbi.upenn.edu]
Sent: Tuesday, May 23, 2006 7:04 AM
To: dbi-users@perl.org
Cc: Drozdowski, Catharine
Subject: Re: Identify PID for remote database handle
I don't know of any way to do this using DBI or DBD::Oracle.
You might get better answers on an Oracle DBA list (try
http://www.freelists.org/list/oracle-l or http://www.lazydba.com )
This seems to work in Oracle 9.2, but I just hacked it together in a
couple of minutes and it's not thoroughly tested (i.e. testcases =3D 1
with 100% success). =20
Also, there are probably
better ways to find your own SID. This of course assumes that the user
has access to the V$ tables (which they probably shouldn't have).
select vp.spid from v$process vp, v$session vs where vs.sid =3D (select
sid from v$mystat where rownum =3D 1) and vp.addr =3D vs.paddr;
I've been thinking about why you might want this and now I'm not sure
it's the answer you want anyway. Running sqlplus inside of perl seems
redundant for most purposes.
And now that I think about it I'm sure DBI/DBD::Oracle can't help you
here because it is not going to know anything about the sqlplus
connection, just the DBI handle.
So it really is off-topic for this list.
-Chris
On May 22, 2006, at 6:07 PM, Drozdowski, Catharine wrote:
> 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=20
> 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
>
>
>
>
This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.
Re: Identify PID for remote database handle--CLARIFICATION...
am 23.05.2006 19:11:33 von mlists
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?
Re: Identify PID for remote database handle--CLARIFICATION...
am 23.05.2006 23:56:17 von gonzales
Too bad I missed this one. It's a bad mistake to assume _any_ process
gets assigned a PID; something one would understand if they, understood
IPC as in Interprocess Communication, which occurs at a lower OS level,
where Descriptors - which are typically some type of "int" - are used to
identify sibling processes with one another.
There are many processes that run, that are never seen at the OS Admin
level, at least not with/out a great deal of effort.
I wouldn't expect a DBA w/out a formal education in computer science to
understand that, unless they were a _good_ DBA.
Ah, what the heck... I'll send this ;)
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.
>
>
>-----Original Message-----
>From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
>Sent: Tuesday, May 23, 2006 8:51 AM
>To: Drozdowski, Catharine; dbi-users@perl.org
>Subject: RE: Identify PID for remote database handle--CLARIFICATION...
>
>This is somewhat off topic as it has nothing to do with DBI nor Perl.
>However ...
>
>When a connection request is made to an Oracle database instance, the
>TNS listener receives this request. If the listener is configured to
>create dedicated sessions, a new process is created, connected to the
>database instance. This new process opens a socket (tcp) for
>communicating with the client process. The listener then hands this
>socket address back to the client program and returns to listening for
>connection requests.
>
>Now, to identify the PID of this new process, someone else has already
>described the mechanism for getting that information from the DB. If
>you want DB resource usage, you will need to look at the performance
>views V$PROCESS, V$SESSION (wait events), and the ASH and AWR views in
>10gR2.
>
>If you need more information on these views, see the Oracle docs and/or
>talk with your DBA.
>
>--
>Ron Reidy
>Lead DBA
>Array BioPharma, Inc.
>
>-----Original Message-----
>From: Drozdowski, Catharine [mailto:catharine_drozdowski@mentor.com]
>Sent: Tuesday, May 23, 2006 9:32 AM
>To: dbi-users@perl.org
>Subject: RE: Identify PID for remote database handle--CLARIFICATION...
>
> To the DBI/DBD list:
>
>Let me rephrase this question a bit.
>I have a perl program running on server A which makes a remote
>connection to a database running on server B using the DBI/DBD construct
>of a database handle/statement handle. On server A, the perl program has
>a process ID, identified by $$ or $PID.
>
>On server B where the actual DDL inside the statement handle is running,
>resources are being consumed by the database to construct the query
>return set. That resource usage is being accounted for somehow at the OS
>level on server B. My assumption is that they are assigned a PID by the
>OS.... It is this process id which I would like to capture.
>
>I hope this clarifies what I am looking for ...
>
>Thanks,
>catharine
>
>
>
>
>-----Original Message-----
>From: Chris Sarnowski [mailto:csarnows@pcbi.upenn.edu]
>Sent: Tuesday, May 23, 2006 7:04 AM
>To: dbi-users@perl.org
>Cc: Drozdowski, Catharine
>Subject: Re: Identify PID for remote database handle
>
>I don't know of any way to do this using DBI or DBD::Oracle.
> You might get better answers on an Oracle DBA list (try
>http://www.freelists.org/list/oracle-l or http://www.lazydba.com )
>
>This seems to work in Oracle 9.2, but I just hacked it together in a
>couple of minutes and it's not thoroughly tested (i.e. testcases = 1
>with 100% success).
>Also, there are probably
>better ways to find your own SID. This of course assumes that the user
>has access to the V$ tables (which they probably shouldn't have).
>
>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;
>
>
>I've been thinking about why you might want this and now I'm not sure
>it's the answer you want anyway. Running sqlplus inside of perl seems
>redundant for most purposes.
>And now that I think about it I'm sure DBI/DBD::Oracle can't help you
>here because it is not going to know anything about the sqlplus
>connection, just the DBI handle.
>So it really is off-topic for this list.
>
>-Chris
>
>On May 22, 2006, at 6:07 PM, Drozdowski, Catharine wrote:
>
>
>>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
>>
>>
>>
>>
>>
>>
>
>
>
>
>This electronic message transmission is a PRIVATE communication which
>contains information which may be confidential or privileged. The
>information is intended to be for the use of the individual or entity
>named above. If you are not the intended recipient, please be aware that
>any disclosure, copying, distribution or use of the contents of this
>information is prohibited. Please notify the sender of the delivery
>error by replying to this message, or notify us by telephone
>(877-633-2436, ext. 0), and then delete it from your system.
>
>
>