Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioned Table Configuration

Re: Partitioned Table Configuration

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 12 Apr 2005 21:54:31 -0700
Message-ID: <1113367844.419690@yasure>


KMART wrote:

> Would like input on configuration of partitioned table that grows at
> the rate of 8 million rows per day. This is approximately 1.5g of
> storage per day.
> Comtemplating tablespace(s) with multiple data files across six mount
> points with initial and next allocation of 1G.
> Partition question:
> Data is retrieved primarily by day or day and hour of day. Two sub
> categories exist, would partitioning by month or partition for each day
> provide the greatest performance gain when selecting data based on
> single date or multiple dates? Data would be maintained for
> approximately 3-7 years before archived.

Partition by day as a trial scenario and then partition with more granularity if required by testing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Apr 12 2005 - 23:54:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US