Re: database sizing estimates using partitioned indexe

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Tue, 30 Sep 2008 13:20:06 -0500
Message-ID: <e9569ef30809301120o529452bai3d6d0a9a203f165@mail.gmail.com>


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_at_gmail.com>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 ?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 30 2008 - 13:20:06 CDT

Original text of this message