Re: database sizing estimates using partitioned indexe

From: Bradd Piontek <>
Date: Tue, 30 Sep 2008 13:20:06 -0500
Message-ID: <>

I"m a little confused as to what your question is.

Isn't it enough to use USER_SEGMENTS based on segment_name and partition_name??

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
  • William Feather

On Tue, Sep 30, 2008 at 1:09 PM, Dba DBA <>wrote:

> We partitions by day and by month depending on the table. All of our
> partitions have names of the form
> I am trying to calculate sizing estimates/day and by month (so they can
> stay ahead of adding storage).
> since all my partitions have the same name, user_segments is not useful.
> for data I was using using_tab_partitions and taking blocks*blocksize to
> get the size/day.
> I see "leaf blocks" in user ind_partitions. Not sure if that is enough
> blocks to get a good estimate per day. Note that 1 partition is one day or 1
> month.
> any suggestions ?

Received on Tue Sep 30 2008 - 13:20:06 CDT

Original text of this message