[Home] [Help]
View: FND_V$PROCESS
Product: | FND - Application Object Library |
Description: | View of V$PROCESS and V$SESSION needed by the Concurrent Processing and Security features |
Implementation/DBA Data: |
APPS.FND_V$PROCESS
|
View Text
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
Columns
Name |
ADDR |
PID |
SPID |
USERNAME |
SERIAL# |
TERMINAL |
PROGRAM |
BACKGROUND |
LATCHWAIT |
LOCKWAIT |