SELECT * FROM v$process;

ADDR     PID        SPID      USERNAME        SERIAL#    TERMINAL         PROGRAM                                                          B LATCHWAI LATCHSPI
-------- ---------- --------- --------------- ---------- ---------------- ---------------------------------------------------------------- - -------- --------
03C916C8          1                                    0                  PSEUDO                                                                              
03C919B8          2 UNKNOWN   Gavin JT Powell          1 JOE BLOGGS       ORACLE.EXE                                                       1                  
03C91CA8          3 UNKNOWN   Gavin JT Powell          1 JOE BLOGGS       ORACLE.EXE                                                       1                  
03C91F98          4 UNKNOWN   Gavin JT Powell          1 JOE BLOGGS       ORACLE.EXE                                                       1                  
03C92288          5 UNKNOWN   Gavin JT Powell          1 JOE BLOGGS       ORACLE.EXE                                                       1                  
03C92578          6 UNKNOWN   Gavin JT Powell          1 JOE BLOGGS       ORACLE.EXE                                                       1                  
03C92868          7 UNKNOWN   Gavin JT Powell          1 JOE BLOGGS       ORACLE.EXE                                                       1                  
03C92B58          8 UNKNOWN   Gavin JT Powell         24 JOE BLOGGS       ORACLE.EXE