<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-wait-classes-global-by-avg-latency">
      </a>
      30.4.3.48 The wait_classes_global_by_avg_latency and
x$wait_classes_global_by_avg_latency Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045061793232">
  </a>
  <a class="indexterm" name="idm46045061791776">
  </a>
  <a class="indexterm" name="idm46045061790272">
  </a>
  <a class="indexterm" name="idm46045061788752">
  </a>
  <p>
   These views summarize wait class average latencies, grouped by
          event class. By default, rows are sorted by descending average
          latency. Idle events are ignored.
  </p>
  <p>
   An event class is determined by stripping from the event name
          everything after the first three components. For example, the
          class for
   <code class="literal">
    wait/io/file/sql/slow_log
   </code>
   is
   <code class="literal">
    wait/io/file
   </code>
   .
  </p>
  <p>
   The
   <a class="link" href="sys-wait-classes-global-by-avg-latency.html" title="30.4.3.48 The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency Views">
    <code class="literal">
     wait_classes_global_by_avg_latency
    </code>
   </a>
   and
   <a class="link" href="sys-wait-classes-global-by-avg-latency.html" title="30.4.3.48 The wait_classes_global_by_avg_latency and x$wait_classes_global_by_avg_latency Views">
    <code class="literal">
     x$wait_classes_global_by_avg_latency
    </code>
   </a>
   views have these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       event_class
      </code>
     </p>
     <p>
      The event class.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total
      </code>
     </p>
     <p>
      The total number of occurrences of events in the class.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total_latency
      </code>
     </p>
     <p>
      The total wait time of timed occurrences of events in the
              class.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       min_latency
      </code>
     </p>
     <p>
      The minimum single wait time of timed occurrences of
              events in the class.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       avg_latency
      </code>
     </p>
     <p>
      The average wait time per timed occurrence of events in
              the class.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       max_latency
      </code>
     </p>
     <p>
      The maximum single wait time of timed occurrences of
              events in the class.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
