FND_V$PROCESS

Details

• Schema: SECURITY

• Object owner: FND

• Object type: VIEW

Columns

Name
ADDR PID SPID USERNAME SERIAL# TERMINAL PROGRAM BACKGROUND LATCHWAIT LOCKWAIT

Query

SQL_Statement
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