V$DISPATCHER_RATE definition in Oracle Database 11.2
V$DISPATCHER_RATE

select
  NAME,                                    -- NAME VARCHAR2(4)
  PADDR,                                   -- PADDR RAW(8)
  CUR_LOOP_RATE,                           -- CUR_LOOP_RATE NUMBER
  CUR_EVENT_RATE,                          -- CUR_EVENT_RATE NUMBER
  CUR_EVENTS_PER_LOOP,                     -- CUR_EVENTS_PER_LOOP NUMBER
  CUR_MSG_RATE,                            -- CUR_MSG_RATE NUMBER
  CUR_SVR_BUF_RATE,                        -- CUR_SVR_BUF_RATE NUMBER
  CUR_SVR_BYTE_RATE,                       -- CUR_SVR_BYTE_RATE NUMBER
  CUR_SVR_BYTE_PER_BUF,                    -- CUR_SVR_BYTE_PER_BUF NUMBER
  CUR_CLT_BUF_RATE,                        -- CUR_CLT_BUF_RATE NUMBER
  CUR_CLT_BYTE_RATE,                       -- CUR_CLT_BYTE_RATE NUMBER
  CUR_CLT_BYTE_PER_BUF,                    -- CUR_CLT_BYTE_PER_BUF NUMBER
  CUR_BUF_RATE,                            -- CUR_BUF_RATE NUMBER
  CUR_BYTE_RATE,                           -- CUR_BYTE_RATE NUMBER
  CUR_BYTE_PER_BUF,                        -- CUR_BYTE_PER_BUF NUMBER
  CUR_IN_CONNECT_RATE,                     -- CUR_IN_CONNECT_RATE NUMBER
  CUR_OUT_CONNECT_RATE,                    -- CUR_OUT_CONNECT_RATE NUMBER
  CUR_RECONNECT_RATE,                      -- CUR_RECONNECT_RATE NUMBER
  MAX_LOOP_RATE,                           -- MAX_LOOP_RATE NUMBER
  MAX_EVENT_RATE,                          -- MAX_EVENT_RATE NUMBER
  MAX_EVENTS_PER_LOOP,                     -- MAX_EVENTS_PER_LOOP NUMBER
  MAX_MSG_RATE,                            -- MAX_MSG_RATE NUMBER
  MAX_SVR_BUF_RATE,                        -- MAX_SVR_BUF_RATE NUMBER
  MAX_SVR_BYTE_RATE,                       -- MAX_SVR_BYTE_RATE NUMBER
  MAX_SVR_BYTE_PER_BUF,                    -- MAX_SVR_BYTE_PER_BUF NUMBER
  MAX_CLT_BUF_RATE,                        -- MAX_CLT_BUF_RATE NUMBER
  MAX_CLT_BYTE_RATE,                       -- MAX_CLT_BYTE_RATE NUMBER
  MAX_CLT_BYTE_PER_BUF,                    -- MAX_CLT_BYTE_PER_BUF NUMBER
  MAX_BUF_RATE,                            -- MAX_BUF_RATE NUMBER
  MAX_BYTE_RATE,                           -- MAX_BYTE_RATE NUMBER
  MAX_BYTE_PER_BUF,                        -- MAX_BYTE_PER_BUF NUMBER
  MAX_IN_CONNECT_RATE,                     -- MAX_IN_CONNECT_RATE NUMBER
  MAX_OUT_CONNECT_RATE,                    -- MAX_OUT_CONNECT_RATE NUMBER
  MAX_RECONNECT_RATE,                      -- MAX_RECONNECT_RATE NUMBER
  AVG_LOOP_RATE,                           -- AVG_LOOP_RATE NUMBER
  AVG_EVENT_RATE,                          -- AVG_EVENT_RATE NUMBER
  AVG_EVENTS_PER_LOOP,                     -- AVG_EVENTS_PER_LOOP NUMBER
  AVG_MSG_RATE,                            -- AVG_MSG_RATE NUMBER
  AVG_SVR_BUF_RATE,                        -- AVG_SVR_BUF_RATE NUMBER
  AVG_SVR_BYTE_RATE,                       -- AVG_SVR_BYTE_RATE NUMBER
  AVG_SVR_BYTE_PER_BUF,                    -- AVG_SVR_BYTE_PER_BUF NUMBER
  AVG_CLT_BUF_RATE,                        -- AVG_CLT_BUF_RATE NUMBER
  AVG_CLT_BYTE_RATE,                       -- AVG_CLT_BYTE_RATE NUMBER
  AVG_CLT_BYTE_PER_BUF,                    -- AVG_CLT_BYTE_PER_BUF NUMBER
  AVG_BUF_RATE,                            -- AVG_BUF_RATE NUMBER
  AVG_BYTE_RATE,                           -- AVG_BYTE_RATE NUMBER
  AVG_BYTE_PER_BUF,                        -- AVG_BYTE_PER_BUF NUMBER
  AVG_IN_CONNECT_RATE,                     -- AVG_IN_CONNECT_RATE NUMBER
  AVG_OUT_CONNECT_RATE,                    -- AVG_OUT_CONNECT_RATE NUMBER
  AVG_RECONNECT_RATE,                      -- AVG_RECONNECT_RATE NUMBER
  TTL_LOOPS,                               -- TTL_LOOPS NUMBER
  TTL_MSG,                                 -- TTL_MSG NUMBER
  TTL_SVR_BUF,                             -- TTL_SVR_BUF NUMBER
  TTL_CLT_BUF,                             -- TTL_CLT_BUF NUMBER
  TTL_BUF,                                 -- TTL_BUF NUMBER
  TTL_IN_CONNECT,                          -- TTL_IN_CONNECT NUMBER
  TTL_OUT_CONNECT,                         -- TTL_OUT_CONNECT NUMBER
  TTL_RECONNECT,                           -- TTL_RECONNECT NUMBER
  SCALE_LOOPS,                             -- SCALE_LOOPS NUMBER
  SCALE_MSG,                               -- SCALE_MSG NUMBER
  SCALE_SVR_BUF,                           -- SCALE_SVR_BUF NUMBER
  SCALE_CLT_BUF,                           -- SCALE_CLT_BUF NUMBER
  SCALE_BUF,                               -- SCALE_BUF NUMBER
  SCALE_IN_CONNECT,                        -- SCALE_IN_CONNECT NUMBER
  SCALE_OUT_CONNECT,                       -- SCALE_OUT_CONNECT NUMBER
  SCALE_RECONNECT                          -- SCALE_RECONNECT NUMBER
from
  GV$DISPATCHER_RATE
where
  inst_id = USERENV('Instance')

home |  up