## find SID using SPID in DB - Oracle##

 find SID using SPID in oracle database

 

col sid format 9999999

col username format a25

col osuser format a16

select b.spid,a.sid, a.serial#,a.username, a.osuser

from v$session a, v$process b

where a.paddr= b.addr

and b.spid='&spid'

order by b.spid;

Comments

Popular posts from this blog

ORA-01565: error in identifying file '?/dbs/spfile@.ora'

Reboot Exadata Machine

How to combine Oracle .ova files