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

Relevant Pages

  • RE: Identify PID for remote database handle--CLARIFICATION...
    ... I do not know you are a DBA; maybe YOU cannot describe the problem ... Identify PID for remote database handle--CLARIFICATION... ...
    (perl.dbi.users)
  • 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. ... server process that is ... Identify PID for remote database ...
    (perl.dbi.users)
  • RE: Identify PID for remote database handle--CLARIFICATION...
    ... Identify PID for remote database handle--CLARIFICATION... ... If you need more information on these views, see the Oracle docs and/or ... I have a perl program running on server A which makes a remote ...
    (perl.dbi.users)
  • Re: Identify PID for remote database handle--CLARIFICATION...
    ... 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. ... Identify PID for remote database handle--CLARIFICATION... ... If you need more information on these views, see the Oracle docs and/or ... I have a perl program running on server A which makes a remote ...
    (perl.dbi.users)
  • postgresql 8 abort with signal 10
    ... I use postgresql as database for dspam, ... connection because of crash of another server process ... postmaster has commanded this server process to roll back the current ... command. ...
    (freebsd-questions)