Table of Contents
メモ
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;
