<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-waits-by-host-by-latency">
      </a>
      30.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045061743104">
  </a>
  <a class="indexterm" name="idm46045061741648">
  </a>
  <a class="indexterm" name="idm46045061740144">
  </a>
  <a class="indexterm" name="idm46045061738640">
  </a>
  <p>
   These views summarize wait events, grouped by host and event.
          By default, rows are sorted by host and descending total
          latency. Idle events are ignored.
  </p>
  <p>
   The
   <a class="link" href="sys-waits-by-host-by-latency.html" title="30.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views">
    <code class="literal">
     waits_by_host_by_latency
    </code>
   </a>
   and
   <a class="link" href="sys-waits-by-host-by-latency.html" title="30.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views">
    <code class="literal">
     x$waits_by_host_by_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">
       host
      </code>
     </p>
     <p>
      The host from which the connection originated.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       event
      </code>
     </p>
     <p>
      The event name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total
      </code>
     </p>
     <p>
      The total number of occurrences of the event for the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total_latency
      </code>
     </p>
     <p>
      The total wait time of timed occurrences of the event for
              the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       avg_latency
      </code>
     </p>
     <p>
      The average wait time per timed occurrence of the event
              for the host.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       max_latency
      </code>
     </p>
     <p>
      The maximum single wait time of timed occurrences of the
              event for the host.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
