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')