More than 5 years have passed since last update.

OracleでセッションIDからOSのプロセスを調べる方法

oracle

Posted at 2013-08-12

SELECT
  proc.spid, 
  ses.sid, 
  ses.serial#, 
  ses.username, 
  ses.program, 
  ses.machine, 
  ses.osuser
FROM v$session ses, v$process proc
WHERE ses.paddr = proc.addr;

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up