Re: What's my session's pid?

On Tue, 16 Aug 2005 13:30:48 -0700, Bart the bear wrote:

> select spid from v$process
> where addr in (
> select paddr from v$session
> where sid=dbms_support.mysid)

For this to work, package DBMS_SUPPORT needs to be installed. This package is not installed by default and even if it is, an ordinary user normally doesn't have execute privilege. Better version is here:

select spid from v$process
where addr in (

      select paddr from v$session 
      where audsid=sys_context('USERENV','SESSIONID'));

-- 
http://www.mgogala.com