Re: Formula to calculate size of temp segment when analyzing tables/schemas

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Dec 1999 14:54:37 -0000
Message-ID: <945875272.14039.1.nnrp-11.9e984b29@news.demon.co.uk>

I haven't tried to work it out,
but since an analye involves min and max values for each column, and average density, etc, I would experiment around

sum for all columns of

        average column size *
        number of non-null occurences in table *
        2 *
        sample percent +
        an arbitrary overhead (say 64K as a first guess)

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Sybrand Bakker wrote in message
<945619145.24341.0.pluto.d4ee154e_at_news.demon.nl>...
>Hi,
>
>Is there any formula to calculate how much temp segment you need to analyze
>a table / schema? Currently I'm working at a site to get a 'standard' suite
>of maintenance tools (No, they don't want to use OEM as they already have
>Patrol) and they don't like the idea the size needs to be determined by
rule
>of thumb and/or trial and error.
>
>Regards,
>
>--
>Sybrand Bakker, Oracle DBA
>
>
Received on Wed Dec 22 1999 - 08:54:37 CST