Re: Estimate production table size

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 13 May 2003 15:16:57 +0800
Message-ID: <3EC09BE9.3FF0@yahoo.com>

Jack wrote:
>
> I was asked in an interview by the following
> Given a table in development, how do you estimate the table size in
> production.
>
> Can someone give any guideline or point me the places where I should be
> looking at? Thanks.
>
> - Jack

analyze table XXX compute statistics

USER_TABLES gives you average row length and blocks used, and its pretty easy to extrapolate from there

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"

Received on Tue May 13 2003 - 02:16:57 CDT