Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> table reorganizations

table reorganizations

From: Shrake, Jolene <JEShrake_at_Pella.com>
Date: Wed, 07 Jan 2004 11:39:26 -0800
Message-ID: <F001.005DC013.20040107113926@fatcity.com>


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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D480343519-07012004>How do =
you identify=20
tables that are used in full table scans?&nbsp; How often do you run = this=20
query?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D480343519-07012004></SPAN></FONT>&nbsp;</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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US