eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.GV_$DISPATCHER_RATE

Object Details

Object Name:	GV_$DISPATCHER_RATE
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INST_ID
,      NAME
,      PADDR
,      CUR_LOOP_RATE
,      CUR_EVENT_RATE
,      CUR_EVENTS_PER_LOOP
,      CUR_MSG_RATE
,      CUR_SVR_BUF_RATE
,      CUR_SVR_BYTE_RATE
,      CUR_SVR_BYTE_PER_BUF
,      CUR_CLT_BUF_RATE
,      CUR_CLT_BYTE_RATE
,      CUR_CLT_BYTE_PER_BUF
,      CUR_BUF_RATE
,      CUR_BYTE_RATE
,      CUR_BYTE_PER_BUF
,      CUR_IN_CONNECT_RATE
,      CUR_OUT_CONNECT_RATE
,      CUR_RECONNECT_RATE
,      MAX_LOOP_RATE
,      MAX_EVENT_RATE
,      MAX_EVENTS_PER_LOOP
,      MAX_MSG_RATE
,      MAX_SVR_BUF_RATE
,      MAX_SVR_BYTE_RATE
,      MAX_SVR_BYTE_PER_BUF
,      MAX_CLT_BUF_RATE
,      MAX_CLT_BYTE_RATE
,      MAX_CLT_BYTE_PER_BUF
,      MAX_BUF_RATE
,      MAX_BYTE_RATE
,      MAX_BYTE_PER_BUF
,      MAX_IN_CONNECT_RATE
,      MAX_OUT_CONNECT_RATE
,      MAX_RECONNECT_RATE
,      AVG_LOOP_RATE
,      AVG_EVENT_RATE
,      AVG_EVENTS_PER_LOOP
,      AVG_MSG_RATE
,      AVG_SVR_BUF_RATE
,      AVG_SVR_BYTE_RATE
,      AVG_SVR_BYTE_PER_BUF
,      AVG_CLT_BUF_RATE
,      AVG_CLT_BYTE_RATE
,      AVG_CLT_BYTE_PER_BUF
,      AVG_BUF_RATE
,      AVG_BYTE_RATE
,      AVG_BYTE_PER_BUF
,      AVG_IN_CONNECT_RATE
,      AVG_OUT_CONNECT_RATE
,      AVG_RECONNECT_RATE
,      TTL_LOOPS
,      TTL_MSG
,      TTL_SVR_BUF
,      TTL_CLT_BUF
,      TTL_BUF
,      TTL_IN_CONNECT
,      TTL_OUT_CONNECT
,      TTL_RECONNECT
,      SCALE_LOOPS
,      SCALE_MSG
,      SCALE_SVR_BUF
,      SCALE_CLT_BUF
,      SCALE_BUF
,      SCALE_IN_CONNECT
,      SCALE_OUT_CONNECT
,      SCALE_RECONNECT
,      CON_ID
FROM SYS.GV_$DISPATCHER_RATE;

Dependencies

[top of page]

SYS.GV_$DISPATCHER_RATE references the following:

SYS.GV_$DISPATCHER_RATE is referenced by following:

PUBLIC: GV$DISPATCHER_RATE