Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 43 of 179


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

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. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index