Oracle 视图 V$DISPATCHER_RATE 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$DISPATCHER_RATE是一个动态性能视图，显示数据库工作的调度率和每秒的处理数量。它用于评估数据库的资源分配情况，是识别数据库性能问题的重要监控视图。
V$DISPATCHER_RATE显示的信息有：
1、DISPATCHER RATE – 数据库工作的调度率。
2、PROCESSES – 指定时间段中活动的会话数。
3、PROCESSES PER SEC – 每秒钟处理会话的数量。
使用方法：
可以使用下列语句来查询V$DISPATCHER_RATE视图：
SELECT *
FROM V$DISPATCHER_RATE;
官方英文解释
V$DISPATCHER_RATE displays 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:
-
Current statistics (
CUR_columns)Current statistics use samples collected over the most recent time-to-live interval.
-
Historical statistics (
AVG_and most of theMAX_columns)Historical statistics make use of all samples that are no longer current.
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 of the dispatcher process |
|
|
|
Address of the dispatcher process |
|
|
|
Rate at which the dispatcher has been iterating through its dispatching loop, reported over the past |
|
|
|
Rate at which the dispatcher has been processing dispatcher events, reported over the past |
|
|
|
Average number of events the dispatcher has been processing in each iteration through its dispatching loop, reported over the past |
|
|
|
Rate at which the dispatcher has been relaying messages between clients and shared servers, reported over the past |
|
|
|
Rate at which the dispatcher has been relaying buffers to shared servers, reported over the past |
|
|
|
Rate at which the dispatcher has been relaying data to shared servers, reported over the past |
|
|
|
Average number of data types in each buffer relayed to shared servers, reported over the past |
|
|
|
Rate at which the dispatcher has been relaying buffers to clients, reported over the past |
|
|
|
Rate at which the dispatcher has been relaying data to clients, reported over the past |
|
|
|
Average number of data bytes in each buffer relayed to clients, reported over the past |
|
|
|
Rate at which the dispatcher has been relaying buffers to either clients or shared servers, reported over the past |
|
|
|
Rate at which the dispatcher has been relaying data to either clients or shared servers, reported over the past |
|
|
|
Average number of data bytes in each buffer relayed to either clients or shared servers, reported over the past |
|
|
|
Rate at which the dispatcher has been accepting incoming client connections, reported over the past |
|
|
|
Rate at which the dispatcher has been establishing outbound connections, reported over the past |
|
|
|
In a connection pooling setup, the rate at which clients have been reconnecting to the dispatcher, reported over the past |
|
|
|
Maximum rate at which the dispatcher has ever iterated through its dispatching loop, reported in iterations/ |
|
|
|
Maximum rate at which the dispatcher has ever processed dispatcher events, reported in events/ |
|
|
|
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 |
|
|
|
Maximum rate at which the dispatcher has ever relayed messages between clients and shared servers, reported in messages/ |
|
|
|
Maximum rate at which the dispatcher has ever relayed buffers to shared servers, reported in buffers/ |
|
|
|
Maximum rate at which the dispatcher has ever relayed data to shared servers, reported in bytes/ |
|
|
|
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 |
|
|
|
Maximum rate at which the dispatcher has ever relayed buffers to either clients or shared servers, reported in buffers/ |
|
|
|
Maximum rate at which the dispatcher has ever relayed buffers to clients, reported in bytes/ |
|
|
|
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 |
|
|
|
Maximum rate at which the dispatcher has ever relayed buffers to either clients or shared servers, reported in buffers/ |
|
|
|
Maximum rate at which the dispatcher has ever relayed data to either clients or shared servers, reported in bytes/ |
|
|
|
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 |
|
|
|
Maximum rate at which the dispatcher has ever accepted incoming client connections, reported in connections/ |
|
|
|
Maximum rate at which the dispatcher has ever established outbound connections, reported in connections/ |
|
|
|
In a connection pooling setup, the maximum rate at which clients have ever reconnected to this dispatcher, reported in reconnections/ |
|
|
|
Historical average rate at which the dispatcher has iterated through its dispatching loop, reported in iterations/ |
|
|
|
Historical average rate at which the dispatcher has processed dispatcher events, reported in events/ |
|
|
|
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 |
|
|
|
Historical average rate at which the dispatcher has relayed messages between clients and shared servers, reported in messages/ |
|
|
|
Historical average rate at which the dispatcher has relayed buffers to shared servers, reported in buffers/ |
|
|
|
Historical average rate at which the dispatcher has relayed data to shared servers, reported in bytes/ |
|
|
|
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 |
|
|
|
Historical average rate at which the dispatcher has relayed buffers to clients, reported in buffers/ |
|
|
|
Historical average rate at which the dispatcher has relayed data to clients, reported in bytes/ |
|
|
|
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 |
|
|
|
Historical average rate at which the dispatcher has relayed buffers to either clients or shared servers, reported in buffers/ |
|
|
|
Historical average rate at which the dispatcher has relayed data to either clients or shared servers, reported in bytes/ |
|
|
|
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 |
|
|
|
Historical average rate at which the dispatcher has accepted incoming client connections, reported in connections/ |
|
|
|
Historical average rate at which the dispatcher has established outbound connections, reported in connections/ |
|
|
|
In a connection pooling setup, the historical average rate at which clients have reconnected to this dispatcher, reported in reconnections/ |
|
|
|
Time-to-live for “loops” samples, reported in hundredths of a second. Default is |
|
|
|
Time-to-live for “messages” samples, reported in hundredths of a second. Default is |
|
|
|
Time-to-live for “buffers to servers” samples, reported in hundredths of a second. Default is |
|
|
|
Time-to-live for “buffers to clients” samples, reported in hundredths of a second. Default is |
|
|
|
Time-to-live for “buffers to clients/servers” samples, reported in hundredths of a second. Default is |
|
|
|
Time-to-live for “inbound connections” samples, reported in hundredths of a second. Default is |
|
|
|
Time-to-live for “outbound connections” samples, reported in hundredths of a second. Default is |
|
|
|
Time-to-live for “reconnections” samples, reported in hundredths of a second. Default is |
|
|
|
Scale for “loops” statistics, reported in hundredths of a second. Default is |
|
|
|
Scale for “messages” statistics, reported in hundredths of a second. Default is |
|
|
|
Scale for “buffers to servers” statistics, reported in hundredths of a second. Default is |
|
|
|
Scale for “buffers to clients” statistics, reported in hundredths of a second. Default is |
|
|
|
Scale for “buffers to clients/servers” statistics, reported in hundredths of a second. Default is |
|
|
|
Scale for “inbound connections” statistics, reported in hundredths of a second. Default is |
|
|
|
Scale for “outbound connections” statistics, reported in hundredths of a second. Default is |
|
|
|
Scale for “reconnections” statistics, reported in hundredths of a second. Default is |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
