[Home] [Help]
VIEW: APPS.FND_V$PROCESS
Source
View Text - Preformatted
SELECT P.ADDR , P.PID , S.PROCESS , S.OSUSER , P.SERIAL# , S.TERMINAL , S.PROGRAM , P.BACKGROUND , P.LATCHWAIT , S.LOCKWAIT FROM V$PROCESS P, V$SESSION S WHERE P.ADDR = S.PADDR
View Text - HTML Formatted
SELECT P.ADDR
, P.PID
, S.PROCESS
, S.OSUSER
, P.SERIAL#
, S.TERMINAL
, S.PROGRAM
, P.BACKGROUND
, P.LATCHWAIT
, S.LOCKWAIT
FROM V$PROCESS P
, V$SESSION S
WHERE P.ADDR = S.PADDR