<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-schema-table-statistics">
      </a>
      30.4.3.29 The schema_table_statistics and x$schema_table_statistics Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045062404224">
  </a>
  <a class="indexterm" name="idm46045062402768">
  </a>
  <a class="indexterm" name="idm46045062401264">
  </a>
  <a class="indexterm" name="idm46045062399760">
  </a>
  <p>
   These views summarize table statistics. By default, rows are
          sorted by descending total wait time (tables with most
          contention first).
  </p>
  <p>
   These views user a helper view,
   <code class="literal">
    x$ps_schema_table_statistics_io
   </code>
   .
  </p>
  <p>
   The
   <a class="link" href="sys-schema-table-statistics.html" title="30.4.3.29 The schema_table_statistics and x$schema_table_statistics Views">
    <code class="literal">
     schema_table_statistics
    </code>
   </a>
   and
   <a class="link" href="sys-schema-table-statistics.html" title="30.4.3.29 The schema_table_statistics and x$schema_table_statistics Views">
    <code class="literal">
     x$schema_table_statistics
    </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">
       table_schema
      </code>
     </p>
     <p>
      The schema that contains the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       table_name
      </code>
     </p>
     <p>
      The table name.
     </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 table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_fetched
      </code>
     </p>
     <p>
      The total number of rows read from the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       fetch_latency
      </code>
     </p>
     <p>
      The total wait time of timed read I/O events for the
              table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_inserted
      </code>
     </p>
     <p>
      The total number of rows inserted into the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       insert_latency
      </code>
     </p>
     <p>
      The total wait time of timed insert I/O events for the
              table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_updated
      </code>
     </p>
     <p>
      The total number of rows updated in the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       update_latency
      </code>
     </p>
     <p>
      The total wait time of timed update I/O events for the
              table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_deleted
      </code>
     </p>
     <p>
      The total number of rows deleted from the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       delete_latency
      </code>
     </p>
     <p>
      The total wait time of timed delete I/O events for the
              table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       io_read_requests
      </code>
     </p>
     <p>
      The total number of read requests for the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       io_read
      </code>
     </p>
     <p>
      The total number of bytes read from the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       io_read_latency
      </code>
     </p>
     <p>
      The total wait time of reads from the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       io_write_requests
      </code>
     </p>
     <p>
      The total number of write requests for the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       io_write
      </code>
     </p>
     <p>
      The total number of bytes written to the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       io_write_latency
      </code>
     </p>
     <p>
      The total wait time of writes to the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       io_misc_requests
      </code>
     </p>
     <p>
      The total number of miscellaneous I/O requests for the
              table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       io_misc_latency
      </code>
     </p>
     <p>
      The total wait time of miscellaneous I/O requests for the
              table.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
