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: table partitioning - max number of rows

Re: table partitioning - max number of rows

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 8 Apr 2002 16:15:59 +0100
Message-ID: <1018278906.1621.0.nnrp-14.9e984b29@news.demon.co.uk>

The figures you give are perfectly reasonable for partitioning.

Depending on how you intend to load the data though, how long you want to keep it, and how frequently you expect to clear it down, you might find one partition per day more effective. And at 25 bytes per row, you might want to consider partitioned IOTs.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Heiko wrote in message ...

>Hello,
>
>i'm going to set up a table containing meassurement data. This table
>will have approx. 7 million rows inserted each day (2000 million each
>year). The average row size is about 25 bytes.
>
>Is a table of that size too big for partitioning (I intend to create
>one partition per month) ? Is there a limit on how big a partitioned
>table should be?
>
>Is it better to split the data into several tables?
>
>Thanks for your help.
>
>Heiko
Received on Mon Apr 08 2002 - 10:15:59 CDT

Original text of this message

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