database sizing estimates using partitioned indexe
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Tue, 30 Sep 2008 14:09:32 -0400
Message-ID: <f30139790809301109m33b3ebcard1e36f42f527cd1c@mail.gmail.com>
Date: Tue, 30 Sep 2008 14:09:32 -0400
Message-ID: <f30139790809301109m33b3ebcard1e36f42f527cd1c@mail.gmail.com>
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-lReceived on Tue Sep 30 2008 - 13:09:32 CDT