Re: database sizing estimates using partitioned indexe

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
        direction."
 -- William Feather


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

> We partitions by day and by month depending on the table. All of our
> partitions have names of the form
>
> PART_YYYYMMDD or PART_YYYYMM
>
> 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 ?
>

Other related posts: