V$SHARED_SERVER definition in Oracle Database 11.2
V$SHARED_SERVER

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

home |  up