<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-io-by-thread-by-latency">
      </a>
      30.4.3.10 The io_by_thread_by_latency and x$io_by_thread_by_latency Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045063055632">
  </a>
  <a class="indexterm" name="idm46045063054176">
  </a>
  <a class="indexterm" name="idm46045063052672">
  </a>
  <a class="indexterm" name="idm46045063051168">
  </a>
  <p>
   These views summarize I/O consumers to display time waiting
          for I/O, grouped by thread. By default, rows are sorted by
          descending total I/O latency.
  </p>
  <p>
   The
   <a class="link" href="sys-io-by-thread-by-latency.html" title="30.4.3.10 The io_by_thread_by_latency and x$io_by_thread_by_latency Views">
    <code class="literal">
     io_by_thread_by_latency
    </code>
   </a>
   and
   <a class="link" href="sys-io-by-thread-by-latency.html" title="30.4.3.10 The io_by_thread_by_latency and x$io_by_thread_by_latency Views">
    <code class="literal">
     x$io_by_thread_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">
       user
      </code>
     </p>
     <p>
      For foreground threads, the account associated with the
              thread. For background threads, the thread name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total
      </code>
     </p>
     <p>
      The total number of I/O events for the thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       total_latency
      </code>
     </p>
     <p>
      The total wait time of timed I/O events for the thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       min_latency
      </code>
     </p>
     <p>
      The minimum single wait time of timed I/O events for the
              thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       avg_latency
      </code>
     </p>
     <p>
      The average wait time per timed I/O event for the thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       max_latency
      </code>
     </p>
     <p>
      The maximum single wait time of timed I/O events for the
              thread.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       thread_id
      </code>
     </p>
     <p>
      The thread ID.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       processlist_id
      </code>
     </p>
     <p>
      For foreground threads, the processlist ID of the thread.
              For background threads,
      <code class="literal">
       NULL
      </code>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
