Re: database sizing estimates using partitioned indexe
Date: Tue, 30 Sep 2008 13:20:06 -0500
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??
"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
> any suggestions ?