Name

V$DISPATCHER_RATE

Synopsis

The V$DISPATCHER_RATE view returns a large number of dispatcher statistics. One row is returned for each dispatcher. Table 7.3 summarizes the columns in this view. For each of the rate-based statistics that is tracked, the view returns values for the current rate, the maximum rate from the time the dispatcher was started, and the average rate. The view also returns information about the time scale on which the rates are based.

The SCALE_xxx columns return time scales. These time scales are expressed in hundredths of a second. The CUR_xxx, MAX_xxx, and AVG_xxx columns report on the current, maximum, and average number of events over the life of a dispatcher. For example, take a look at the output from the following query:

SQL> SELECT NAME, SCALE_BUF, CUR_BYTE_RATE, MAX_BYTE_RATE, AVG_BYTE_RATE
  2  FROM V$DISPATCHER_RATE;

NAME  SCALE_BUF CUR_BYTE_RATE MAX_BYTE_RATE AVG_BYTE_RATE
---- ---------- ------------- ------------- -------------
D000         10             0           640             0

The scale in this instance is 10 hundredths, or 1/10, of a second. The number of bytes transmitted during the most recent interval by dispatcher D000 is 0. The maximum rate transmitted in a 1/10th second interval since the dispatcher was started is 640 bytes. The average value of indicates that the dispatcher has not been very busy. (In truth, the average would have to be slightly above zero, but it’s so close to zero that it’s been rounded down to that value for display purposes.)

Table G-3. V$DISPATCHER_RATE ...

Get Oracle Net8 Configuration and Troubleshooting now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.