RE: Collecting table statistics

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Fri, 21 Jul 2000 12:20:51 -0700
Message-Id: <10565.112676@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF348.C89F4820
Content-Type: text/plain;

charset="iso-8859-1"

yes ..

-----Original Message-----
From: Chuck Hamilton [mailto:chuck_hamilton_at_yahoo.com] Sent: Friday, July 21, 2000 11:57 AM
To: Multiple recipients of list ORACLE-L Subject: Collecting table statistics

Some time ago I thought I saw something on the list about 8i having the ability to automatically collecet statistics on tables with needing to issue the ANALYZE TABLE command. Can someone tell me how this works or point me to a document that describes it? Is this what the MONITORING clause of ALTER/CREATE table is for?

Do You Yahoo!?
Get Yahoo! Mail <http://mail.yahoo.com/> - Free email you can access from anywhere!

------_=_NextPart_001_01BFF348.C89F4820
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV>yes ..
</DIV>
<BLOCKQUOTE>

<DIV align=left class=OutlookMessageHeader dir=ltr>-----Original Message----- From: Chuck Hamilton [mailto:chuck_hamilton_at_yahoo.com] Sent: Friday, July 21, 2000 11:57 AM To: Multiple recipients of list ORACLE-L Subject: Collecting table statistics </DIV> Some time ago I thought I saw something on the list about 8i having the ability to automatically collecet statistics on tables with needing to issue the ANALYZE TABLE command. Can someone tell me how this works or point me to a document that describes it? Is this what the MONITORING clause of ALTER/CREATE table is for?

  <P><BR>
  <HR SIZE=1>
  <B>Do You Yahoo!?</B><BR>Get Yahoo! Mail

Free email you can access from anywhere!</BLOCKQUOTE></BODY></HTML>

Received on Fri Jul 21 2000 - 14:20:51 CDT