FAQ
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
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


Search Discussions

  • Reidy, Ron at May 23, 2006 at 3:51 pm
    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
    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
    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.
  • Drozdowski, Catharine at May 23, 2006 at 4:11 pm
    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
    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
    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
    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.
  • Reidy, Ron at May 23, 2006 at 4:27 pm
    No, I do not know you are a DBA; maybe YOU cannot describe the problem
    well enough.

    -----Original Message-----
    From: Drozdowski, Catharine
    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
    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
    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
    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.
  • JupiterHost.Net at May 23, 2006 at 5:12 pm

    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
    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?
  • Tyler MacDonald at May 23, 2006 at 5:16 pm

    JupiterHost.Net 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 the
    $dbh process ont he DB server (local or remote)
    Depends on the DBD driver on the backend. eg; with postgres you do
    it like this:

    my $pid = $dbh->{pg_pid};

    Cheers,
    Tyler
  • Louis gonzales at May 23, 2006 at 9:58 pm
    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
    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
    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
    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
    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.

  • Drozdowski, Catharine at May 23, 2006 at 5:37 pm
    Yep, you got it...

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

    -----Original Message-----
    From: 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
    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?
  • Thomas Hilbig at May 23, 2006 at 6:28 pm
    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

    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
    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
  • Listmail at May 23, 2006 at 10:04 pm
    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

    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
    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
    ---------------------------------------------------------------------------------------------------

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedMay 23, '06 at 3:32p
activeMay 23, '06 at 10:04p
posts10
users7
websitedbi.perl.org

People

Translate

site design / logo © 2022 Grokbase