Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

show_spid.sql

Download Script

select spid 
from v$process a, v$session b
where b.sid = &SID
and   b.paddr = a.addr;