O'Reilly logo

Oracle Net8 Configuration and Troubleshooting by Jonathan Gennick, Hugo Toledo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required