select
  SERVER_NAME,                             -- SERVER_NAME VARCHAR2(4)
  STATUS,                                  -- STATUS VARCHAR2(9)
  PID,                                     -- PID NUMBER
  SPID,                                    -- SPID VARCHAR2(24)
  SID,                                     -- SID NUMBER
  SERIAL#                                  -- SERIAL# NUMBER
from
  GV$PX_PROCESS
where
  inst_id = USERENV('Instance')