Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to identify spid of caller
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