V$PX_SESSTAT definition in Oracle Database 11.2
V$PX_SESSTAT

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
  statistic#,                              -- STATISTIC# NUMBER
  value                                    -- VALUE NUMBER
from
  GV$PX_SESSTAT
where
  inst_id = USERENV('Instance')

home |  up