System Tables Views Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Tables Views
  4. 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>