demo01.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 8 行

select a.spid dedicated_server,
           b.process clientpid
  from v$process a, v$session b
 where a.addr = b.paddr
   and b.sid = (select sid from v$mystat where rownum=1)
/