Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to identify spid of caller

How to identify spid of caller

From: Bill Wine <biwine_at_vassar.edu>
Date: 1997/02/06
Message-ID: <5dda21$6bq@vassun.vassar.edu>#1/1

If I am logged into the database more than once, with the same username, terminal, program, and I do this query:

select * from v$session where username = user

how would I find which row corresponds to the current, or calling process? This would be from a PL/SQL procedure.

Thanks for your help.

Bill Received on Thu Feb 06 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US