select
  addr,                                    -- ADDR RAW(8)
  pid,                                     -- PID NUMBER
  spid,                                    -- SPID VARCHAR2(24)
  pname,                                   -- PNAME VARCHAR2(5)
  username,                                -- USERNAME VARCHAR2(15)
  serial#,                                 -- SERIAL# NUMBER
  terminal,                                -- TERMINAL VARCHAR2(16)
  program,                                 -- PROGRAM VARCHAR2(64)
  traceid,                                 -- TRACEID VARCHAR2(255)
  tracefile,                               -- TRACEFILE VARCHAR2(513)
  background,                              -- BACKGROUND VARCHAR2(1)
  latchwait,                               -- LATCHWAIT VARCHAR2(16)
  latchspin,                               -- LATCHSPIN VARCHAR2(16)
  pga_used_mem,                            -- PGA_USED_MEM NUMBER
  pga_alloc_mem,                           -- PGA_ALLOC_MEM NUMBER
  pga_freeable_mem,                        -- PGA_FREEABLE_MEM NUMBER
  pga_max_mem                              -- PGA_MAX_MEM NUMBER
from
  gv$process
where
  inst_id = USERENV('Instance')