Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> table reorganizations
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C3D556.6A90BCC0"
------_=_NextPart_001_01C3D556.6A90BCC0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
What SQL statement do you use to identify tables that need
reorganization?
=20
How do you identify tables that are used in full table scans? How often
do you run this query?
=20
Thanks,
Jolene
------_=_NextPart_001_01C3D556.6A90BCC0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D480343519-07012004>What =
SQL statement=20
do you use to identify tables that need =
reorganization?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D480343519-07012004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D480343519-07012004>How do =
you identify=20
tables that are used in full table scans? How often do you run =
this=20
query?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D480343519-07012004></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D480343519-07012004>Thanks,</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D480343519-07012004>Jolene</SPAN></FONT></DIV></BODY></HTML>
------_=_NextPart_001_01C3D556.6A90BCC0--
--------------InterScan_NT_MIME_Boundary--
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shrake, Jolene INET: JEShrake_at_Pella.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jan 07 2004 - 13:39:26 CST
![]() |
![]() |