Query v$process a, v$session : process « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. process

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>








Related examples in the same category

1.Query process for The Current Usage of the PGA Memory
2.Get oracle installation path