<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-schema-tables-with-full-table-scans">
      </a>
      30.4.3.31 The schema_tables_with_full_table_scans and
x$schema_tables_with_full_table_scans Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045062286656">
  </a>
  <a class="indexterm" name="idm46045062285136">
  </a>
  <a class="indexterm" name="idm46045062283616">
  </a>
  <a class="indexterm" name="idm46045062282096">
  </a>
  <p>
   These views display which tables are being accessed with full
          table scans. By default, rows are sorted by descending rows
          scanned.
  </p>
  <p>
   The
   <a class="link" href="sys-schema-tables-with-full-table-scans.html" title="30.4.3.31 The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans Views">
    <code class="literal">
     schema_tables_with_full_table_scans
    </code>
   </a>
   and
   <a class="link" href="sys-schema-tables-with-full-table-scans.html" title="30.4.3.31 The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans Views">
    <code class="literal">
     x$schema_tables_with_full_table_scans
    </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">
       object_schema
      </code>
     </p>
     <p>
      The schema name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       object_name
      </code>
     </p>
     <p>
      The table name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       rows_full_scanned
      </code>
     </p>
     <p>
      The total number of rows scanned by full scans of the
              table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       latency
      </code>
     </p>
     <p>
      The total wait time of full scans of the table.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
