Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$DISPATCHER_RATE

This view provides rate statistics for a number of activities performed by the dispatcher processes. Collected samples have an activity-specific "time-to-live" (TTL_* columns). Statistics are reported over the following two types of time intervals:

At the time of collection, a sample is current. After the time-to-live has elapsed, the sample becomes historical. Each type of activity has a specific scale (represented by the SCALE_* columns) at which the statistics are reported.

Column Datatype Description

NAME

CHAR

Name of the dispatcher process

PADDR

RAW(4 | 8)

Address of the dispatcher process

CUR_LOOP_RATE

NUMBER

Rate at which the dispatcher has been iterating through its dispatching loop, reported over the past TTL_LOOPS, in iterations/SCALE_LOOPS

CUR_EVENT_RATE

NUMBER

Rate at which the dispatcher has been processing dispatcher events, reported over the past TTL_LOOPS, in events/SCALE_LOOPS. Such dispatcher events include network events and shared server requests.

CUR_EVENTS_PER_LOOP

NUMBER

Average number of events the dispatcher has been processing in each iteration through its dispatching loop, reported over the past TTL_LOOPS, in events/iteration

CUR_MSG_RATE

NUMBER

Rate at which the dispatcher has been relaying messages between clients and shared servers, reported over the past TTL_MSG, in messages/SCALE_MSG

CUR_SVR_BUF_RATE

NUMBER

Rate at which the dispatcher has been relaying buffers to shared servers, reported over the past TTL_SVR_BUF, in messages/SCALE_SVR_BUF

CUR_SVR_BYTE_RATE

NUMBER

Rate at which the dispatcher has been relaying data to shared servers, reported over the past TTL_SVR_BUF, in bytes/SCALE_SVR_BUF

CUR_SVR_BYTE_PER_BUF

NUMBER

Average number of data types in each buffer relayed to shared servers, reported over the past TTL_SVR_BUF, in bytes/buffer

CUR_CLT_BUF_RATE

NUMBER

Rate at which the dispatcher has been relaying buffers to clients, reported over the past TTL_CLT_BUF, in buffers/SCALE_CLT_BUF

CUR_CLT_BYTE_RATE

NUMBER

Rate at which the dispatcher has been relaying data to clients, reported over the past TTL_CLT_BUF, in bytes/SCALE_CLT_BUF

CUR_CLT_BYTE_PER_BUF

NUMBER

Average number of data bytes in each buffer relayed to clients, reported over the past TTL_CLT_BUF, in bytes/buffer

CUR_BUF_RATE

NUMBER

Rate at which the dispatcher has been relaying buffers to either clients or shared servers, reported over the past TTL_BUF, in bytes/SCALE_BUF

CUR_BYTE_RATE

NUMBER

Rate at which the dispatcher has been relaying data to either clients or shared servers, reported over the past TTL_BUF, in bytes/SCALE_BUF

CUR_BYTE_PER_BUF

NUMBER

Average number of data bytes in each buffer relayed to either clients or shared servers, reported over the past TTL_BUF, in bytes/buffer

CUR_IN_CONNECT_RATE

NUMBER

Rate at which the dispatcher has been accepting incoming client connections, reported over the past TTL_IN_CONNECT, in connections/SCALE_IN_CONNECT

CUR_OUT_CONNECT_RATE

NUMBER

Rate at which the dispatcher has been establishing outbound connections, reported over the past TTL_OUT_CONNECT, in connections/SCALE_OUT_CONNECT

CUR_RECONNECT_RATE

NUMBER

In a connection pooling setup, the rate at which clients have been reconnecting to the dispatcher, reported over the past TTL_RECONNECT, in reconnections/SCALE_RECONNECT

MAX_LOOP_RATE

NUMBER

Maximum rate at which the dispatcher has ever iterated through its dispatching loop, reported in iterations/SCALE_LOOPS, over the dispatcher's lifetime excluding the past TTL_LOOPS

MAX_EVENT_RATE

NUMBER

Maximum rate at which the dispatcher has ever processed dispatcher events, reported in events/SCALE_LOOPS, over the dispatcher's lifetime excluding the past TTL_LOOPS

MAX_EVENTS_PER_LOOP

NUMBER

Maximum number of events the dispatcher has ever processed in one iteration through its dispatching loop, reported in events/iteration, over the dispatcher's lifetime

MAX_MSG_RATE

NUMBER

Maximum rate at which the dispatcher has ever relayed messages between clients and shared servers, reported in messages/SCALE_MSG, over the dispatcher's lifetime excluding the past TTL_MSG

MAX_SVR_BUF_RATE

NUMBER

Maximum rate at which the dispatcher has ever relayed buffers to shared servers, reported in buffers/SCALE_SVR_BUF, over the dispatcher's lifetime excluding the past TTL_SVR_BUF

MAX_SVR_BYTE_RATE

NUMBER

Maximum rate at which the dispatcher has ever relayed data to shared servers, reported in bytes/SCALE_SVR_BUF, over the dispatcher's lifetime excluding the past TTL_SVR_BUF

MAX_SVR_BYTE_PER_BUF

NUMBER

Maximum number of data bytes the dispatcher has ever relayed in one buffer to a client, reported in bytes/buffer, over the dispatcher's lifetime

MAX_CLT_BUF_RATE

NUMBER

Maximum rate at which the dispatcher has ever relayed buffers to either clients or shared servers, reported in buffers/SCALE_CLT_BUF, over the dispatcher's life time excluding the past TTL_CLT_BUF

MAX_CLT_BYTE_RATE

NUMBER

Maximum rate at which the dispatcher has ever relayed buffers to clients, reported in bytes/SCALE_CLT_BUF, over the dispatcher's lifetime excluding the last TTL_CLT_BUF

MAX_CLT_BYTE_PER_BUF

NUMBER

Maximum number of data bytes the dispatcher has ever relayed in one buffer to a client, reported in bytes/buffer, over the dispatcher's lifetime

MAX_BUF_RATE

NUMBER

Maximum rate at which the dispatcher has ever relayed buffers to either clients or shared servers, reported in buffers/SCALE_BUF, over the dispatcher's lifetime, excluding the past TTL_BUF

MAX_BYTE_RATE

NUMBER

Maximum rate at which the dispatcher has ever relayed data to either clients or shared servers, reported in bytes/SCALE_BUF, over the dispatcher's lifetime excluding the past TTL_BUF

MAX_BYTE_PER_BUF

NUMBER

Maximum number of data bytes the dispatcher has ever relayed in one buffer to either a client or a shared server, reported in bytes/buffer, over the dispatcher's lifetime

MAX_IN_CONNECT_RATE

NUMBER

Maximum rate at which the dispatcher has ever accepted incoming client connections, reported in connections/SCALE_IN_CONNECT, over the dispatcher's lifetime excluding the past TTL_IN_CONNECT

MAX_OUT_CONNECT_RATE

NUMBER

Maximum rate at which the dispatcher has ever established outbound connections, reported in connections/SCALE_OUT_CONNECT, over the dispatcher's lifetime excluding the past TTL_OUT_CONNECT

MAX_RECONNECT_RATE

NUMBER

In a connection pooling setup, the maximum rate at which clients have ever reconnected to this dispatcher, reported in reconnections/SCALE_RECONNECT, over the dispatcher's lifetime excluding the past TTL_RECONNECT

AVG_LOOP_RATE

NUMBER

Historical average rate at which the dispatcher has iterated through its dispatching loop, reported in iterations/SCALE_LOOPS, over the dispatcher's lifetime excluding the past TTL_LOOPS

AVG_EVENT_RATE

NUMBER

Historical average rate at which the dispatcher has processed dispatcher events, reported in events/SCALE_LOOPS, over the dispatcher's lifetime excluding the past TTL_LOOPS

AVG_EVENTS_PER_LOOP

NUMBER

Historical average number of events the dispatcher has processed in one iteration through its dispatching loop, reported in events/iteration, over the dispatcher's lifetime excluding the past TTL_LOOPS

AVG_MSG_RATE

NUMBER

Historical average rate at which the dispatcher has relayed messages between clients and shared servers, reported in messages/SCALE_MSG, over the dispatcher's lifetime excluding the past TTL_MSG

AVG_SVR_BUF_RATE

NUMBER

Historical average rate at which the dispatcher has relayed buffers to shared servers, reported in buffers/SCALE_SVR_BUF, over the dispatcher's lifetime excluding the past TTL_SVR_BUF

AVG_SVR_BYTE_RATE

NUMBER

Historical average rate at which the dispatcher has relayed data to shared servers, reported in bytes/SCALE_SVR_BUF, over the dispatcher's lifetime excluding the past TTL_SVR_BUF

AVG_SVR_BYTE_PER_BUF

NUMBER

Historical average number of data bytes per buffer the dispatcher has relayed to shared servers, reported in bytes/buffer, over the dispatcher's lifetime excluding the past TTL_SVR_BUF

AVG_CLT_BUF_RATE

NUMBER

Historical average rate at which the dispatcher has relayed buffers to clients, reported in buffers/SCALE_CLT_BUF, over the dispatcher's lifetime excluding the past TTL_CLT_BUF

AVG_CLT_BYTE_RATE

NUMBER

Historical average rate at which the dispatcher has relayed data to clients, reported in bytes/SCALE_CLT_BUF, over the dispatcher's lifetime excluding the past TTL_CLT_BUF

AVG_CLT_BYTE_PER_BUF

NUMBER

Historical average number of data bytes per buffer the dispatcher has relayed to clients, reported in bytes/buffer, over the dispatcher's lifetime excluding the past TTL_CLT_BUF

AVG_BUF_RATE

NUMBER

Historical average rate at which the dispatcher has relayed buffers to either clients or shared servers, reported in buffers/SCALE_BUF, over the dispatcher's lifetime excluding the past TTL_BUF

AVG_BYTE_RATE

NUMBER

Historical average rate at which the dispatcher has relayed data to either clients or shared servers, reported in bytes/SCALE_BUF, over the dispatcher's lifetime excluding the past TTL_BUF

AVG_BYTE_PER_BUF

NUMBER

Historical average number of data bytes per buffer the dispatcher has relayed to either clients or shared servers, reported in bytes/buffer, over the dispatcher's lifetime excluding the past TTL_BUF

AVG_IN_CONNECT_RATE

NUMBER

Historical average rate at which the dispatcher has accepted incoming client connections, reported in connections/SCALE_IN_CONNECT, over the dispatcher's lifetime excluding the past TTL_IN_CONNECT

AVG_OUT_CONNECT_RATE

NUMBER

Historical average rate at which the dispatcher has established outbound connections, reported in connections/SCALE_OUT_CONNECT, over the dispatcher's lifetime excluding the past TTL_OUT_CONNECT

AVG_RECONNECT_RATE

NUMBER

In a connection pooling setup, the historical average rate at which clients have reconnected to this dispatcher, reported in reconnections/SCALE_RECONNECT, over the dispatcher's lifetime excluding the past TTL_RECONNECT

TTL_LOOPS

NUMBER

Time-to-live for "loops" samples, reported in hundredths of a second. Default is 10 minutes.

TTL_MSG

NUMBER

Time-to-live for "messages" samples, reported in hundredths of a second. Default is 10 seconds.

TTL_SVR_BUF

NUMBER

Time-to-live for "buffers to servers" samples, reported in hundredths of a second. Default is 1 second.

TTL_CLT_BUF

NUMBER

Time-to-live for "buffers to clients" samples, reported in hundredths of a second. Default is 1 second.

TTL_BUF

NUMBER

Time-to-live for "buffers to clients/servers" samples, reported in hundredths of a second. Default is 1 second.

TTL_IN_CONNECT

NUMBER

Time-to-live for "inbound connections" samples, reported in hundredths of a second. Default is 10 minutes.

TTL_OUT_CONNECT

NUMBER

Time-to-live for "outbound connections" samples, reported in hundredths of a second. Default is 10 minutes.

TTL_RECONNECT

NUMBER

Time-to-live for "reconnections" samples, reported in hundredths of a second. Default is 10 minutes.

SCALE_LOOPS

NUMBER

Scale for "loops" statistics, reported in hundredths of a second. Default is 1 minute.

SCALE_MSG

NUMBER

Scale for "messages" statistics, reported in hundredths of a second. Default is 1 second.

SCALE_SVR_BUF

NUMBER

Scale for "buffers to servers" statistics, reported in hundredths of a second. Default is 1/10 second.

SCALE_CLT_BUF

NUMBER

Scale for "buffers to clients" statistics, reported in hundredths of a second. Default is 1/10 second.

SCALE_BUF

NUMBER

Scale for "buffers to clients/servers" statistics, reported in hundredths of a second. Default is 1/10 second.

SCALE_IN_CONNECT

NUMBER

Scale for "inbound connections" statistics, reported in hundredths of a second. Default is 1 minute.

SCALE_OUT_CONNECT

NUMBER

Scale for "outbound connections" statistics, reported in hundredths of a second. Default is 1 minute.

SCALE_RECONNECT

NUMBER

Scale for "reconnections" statistics, reported in hundredths of a second. Default is 1 minute.