V$PX_SESSION definition in Oracle Database 11.2
V$PX_SESSION

select
  saddr,                                   -- SADDR RAW(8)
  sid,                                     -- SID NUMBER
  serial#,                                 -- SERIAL# NUMBER
  qcsid,                                   -- QCSID NUMBER
  qcserial#,                               -- QCSERIAL# NUMBER
  qcinst_id,                               -- QCINST_ID NUMBER
  server_group,                            -- SERVER_GROUP NUMBER
  server_set,                              -- SERVER_SET NUMBER
  server#,                                 -- SERVER# NUMBER
  degree,                                  -- DEGREE NUMBER
  req_degree                               -- REQ_DEGREE NUMBER
from
  GV$PX_SESSION
where
  inst_id = USERENV('Instance')

home |  up