oracleのプロセス確認SQL

メモ

SELECT
  P.PID ORACLE_PID,
  P.SPID OS_PID,
  S.STATUS,
  S.USERNAME ORACLE_USER,
  S.OSUSER OS_USER,
  S.TERMINAL,
  S.PROGRAM,
  TO_CHAR(S.LOGON_TIME, ‘YYYY/MM/DD HH24:MI:SS’) LOGON_TIME
  FROM V$PROCESS P
  LEFT OUTER JOIN V$SESSION S
    ON P.ADDR = S.PADDR
  WHERE P.BACKGROUND IS NULL
    AND P.PID > 1
  ORDER BY PID;