RE: database sizing estimates using partitioned indexe

From: Michael McMullen <>
Date: Tue, 30 Sep 2008 14:37:04 -0400
Message-ID: <BAY141-DAV1DF085B9D5C7DA8001194A6430@phx.gbl>
Message-ID: <002e01c9232b$895fc290$>

I think user_segments would do the job nicely. What's wrong with using segment_name along with partition_name?  

From: [] On Behalf Of Dba DBA
Sent: Tuesday, September 30, 2008 2:10 PM To:
Subject: database sizing estimates using partitioned indexe  

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:37:04 CDT

Original text of this message