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

2006-05-23 Thread listmail
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:[EMAIL

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

2006-05-23 Thread louis gonzales
bi-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:[EMAIL PROTECTED] Sent: Tuesday, May 23, 200

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

2006-05-23 Thread Thomas Hilbig
, you got it... > > PS I did send Ron/Chris separate email to make > nice > > -Original Message- > From: JupiterHost.Net > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 10:12 AM > To: dbi-users@perl.org > Subject: Re: Identify PID for remote data

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

2006-05-23 Thread Drozdowski, Catharine
Yep, you got it... PS I did send Ron/Chris separate email to make nice -Original Message- From: JupiterHost.Net [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 10:12 AM To: dbi-users@perl.org Subject: Re: Identify PID for remote database handle--CLARIFICATION... Reidy, Ron

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

2006-05-23 Thread Tyler MacDonald
JupiterHost.Net <[EMAIL PROTECTED]> wrote: > >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 th

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

2006-05-23 Thread JupiterHost.Net
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:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 10:11 AM To: Reidy, Ron; dbi-users@perl.org Subject: RE: Identify PID for

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

2006-05-23 Thread Reidy, Ron
No, I do not know you are a DBA; maybe YOU cannot describe the problem well enough. -Original Message- From: Drozdowski, Catharine [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 10:11 AM To: Reidy, Ron; dbi-users@perl.org Subject: RE: Identify PID for remote database handle

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

2006-05-23 Thread Drozdowski, Catharine
docs and/or talk with your DBA. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Drozdowski, Catharine [mailto:[EMAIL PROTECTED] 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

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

2006-05-23 Thread Reidy, Ron
. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Drozdowski, Catharine [mailto:[EMAIL PROTECTED] 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

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

2006-05-23 Thread Drozdowski, Catharine
: 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 togeth

Re: Identify PID for remote database handle

2006-05-23 Thread Chris Sarnowski
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

Identify PID for remote database handle

2006-05-22 Thread Drozdowski, Catharine
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 Cat