Personal tools
You are here: Home → Oracle → How To's → How to get the SID, SPID, USERNAME, TERMINAL & Application from oracle database
Navigation
Log in


Forgot your password?
 
Document Actions

How to get the SID, SPID, USERNAME, TERMINAL & Application from oracle database

The SID, SPID, USERNAME, TERMINAL & Application query :


select
        s.sid, p.spid, substr(s.username,1,20) username, s.terminal, p.Program
  from
       v$session s, v$process p
 where
       s.paddr = p.addr
   and
       s.sid = (select sid from v$mystat where rownum=1)
;
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls