Mega Code Archive
Categories
/
Oracle PLSQL
/
System Tables Views
Query v$process a, v$session
SQL> SQL> select a.spid 2 from v$process a, v$session b 3 where a.addr = b.paddr 4 and b.audsid = userenv('sessionid') 5 / SPID ------------ 972 SQL>