Re: ANALYZE

From: Tom Pall <tom_at_cdproc.com>
Date: Tue, 31 Oct 2000 12:16:23 -0600
Message-Id: <10666.120697@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0645_01C04334.62612D30 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

ANALYZE_SCHEMAThis is not the answer to wanted. However, DBMS_STATS is = a new and improved.
It does not, for example, drag your tables and indexes through the = buffer cache the way
analyze does.

My instructor for an Oracle Internals class I recently took spoke = glowingly about dbms_stats,
saying the sampling was so improved that if you want to know the = distribution of a value within a
column of a table, plus or minus a small error, instead of issuing = select count(*), use dbms_stats
with a very small sample size. You'll get the results much more = quickly, and very accurately.

Original Message -----=20 From: DEMANCHE Luc (Cetelem)=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, October 31, 2000 8:15 AM Subject: ANALYZE_SCHEMA

Hi all,=20

Since we are on Oracle 816, dbms_utility.analyze_schema need more = space in temporary tablespace.=20
I increased my temporary tablespace from 1,5gig to 2,5 gig, and = analyze_schema ask for more ?=20

Has someone ever noticed this ?=20

  TIA=20   Luc Demanche=20
  CETELEM=20
  01-46-39-14-49=20

------=_NextPart_000_0645_01C04334.62612D30 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>ANALYZE_SCHEMA</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>This is not the answer to wanted.  However, =
DBMS_STATS is=20
a new and improved.</FONT></DIV>
<DIV><FONT size=3D2>It does not, for example, drag your tables and =
indexes through=20
the buffer cache the way</FONT></DIV>
<DIV><FONT size=3D2>analyze does.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>My instructor for an Oracle Internals class I =
recently took=20
spoke glowingly about dbms_stats,</FONT></DIV>
<DIV><FONT size=3D2>saying the sampling was so improved that if you want =
to know=20
the distribution of a value within a</FONT></DIV>
<DIV><FONT size=3D2>column of a table, plus or minus a small error, =
instead of=20
issuing select count(*), use dbms_stats</FONT></DIV>
<DIV><FONT size=3D2>with a very small sample size.  You'll get the =
results=20
much more quickly, and very accurately.</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:luc.demanche_at_cetelem.fr"=20   title=3Dluc.demanche_at_cetelem.fr>DEMANCHE Luc (Cetelem)</A> </DIV>   <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, October 31, 2000 = 8:15=20
  AM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> ANALYZE_SCHEMA</DIV>
  <DIV><BR></DIV>
  <P><FONT face=3DArial size=3D2>Hi all,</FONT> </P>
  <P><FONT face=3DArial size=3D2>Since we are on Oracle 816,=20

  dbms_utility.analyze_schema need more space in temporary = tablespace.</FONT>=20
  <BR><FONT face=3DArial size=3D2>I increased my temporary tablespace = from 1,5gig to=20
  2,5 gig, and analyze_schema ask for more ?</FONT> </P>   <P><FONT face=3DArial size=3D2>Has someone ever noticed this ?</FONT> =
</P>

  <P><FONT face=3DArial size=3D2>TIA</FONT> </P>   <P><FONT face=3DArial size=3D2>Luc Demanche</FONT> <BR><FONT = face=3DArial=20
  size=3D2>CETELEM</FONT> <BR><FONT face=3DArial = size=3D2>01-46-39-14-49</FONT>=20 Received on Tue Oct 31 2000 - 12:16:23 CST

Re: ANALYZE_SCHEMA