select
NAME, -- NAME VARCHAR2(4)
PADDR, -- PADDR RAW(8)
STATUS, -- STATUS VARCHAR2(16)
MESSAGES, -- MESSAGES NUMBER
BYTES, -- BYTES NUMBER
BREAKS, -- BREAKS NUMBER
CIRCUIT, -- CIRCUIT RAW(8)
IDLE, -- IDLE NUMBER
BUSY, -- BUSY NUMBER
IN_NET, -- IN_NET NUMBER
OUT_NET, -- OUT_NET NUMBER
REQUESTS -- REQUESTS NUMBER
from
GV$SHARED_SERVER
where
inst_id = USERENV('Instance')