DBA Data[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