Re: ANALYZE
Date: 1996/10/21
Message-ID: <NEWTNews.845958245.31135.dafis_at_ppp.test.jccbi.gov>#1/1
In article <547p7p$ga5_at_news2.cais.com>, <friedman_at_cais.com> writes:
> Path: news.ou.edu!news.ecn.uoknor.edu!news.wildstar.net!news.localnet.com!news.sprintlink.net!news-pen-4.sprintlink.net!www.nntp.primenet.com!nntp.primenet.com!news.cais.net!news2.cais.com!not-for-mail
> From: friedman_at_cais.com (TANDEM-TEAM)
> Newsgroups: comp.databases.oracle
> Subject: ANALYZE
> Date: 18 Oct 1996 11:21:29 GMT
> Organization: Sent via CAIS Internet <info_at_cais.com>
> Lines: 9
> Message-ID: <547p7p$ga5_at_news2.cais.com>
> NNTP-Posting-Host: cais.com
> X-Newsreader: TIN [UNIX 1.3 950515BETA PL0]
>
> I am using the ANALYZE table COMPUTE STATISTICS command to determine the
> amount of disk space a very large table is using. The command apparently
> needs lots and lots of temporary space. Two questions:
> 1. Does anyone know why?
> 2. Is there a way around this problem except to add data files to the
> Temporary tablespace?
>
> Thanks
> --
>
Using ESTIMATE STATISTICS will allways return the exacts amount of used
blocks. Other statistics use a sampling of the data. If you need the script
to determine the amount of free space, I could get it for you. I think
ESTIMATE STATISTICS and what is returned is documented in the CONCEPTS MANUAL.
Martin Douglas Received on Mon Oct 21 1996 - 00:00:00 CEST