Re: Pros/cons of using as many table partitions as possible

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 20 Apr 2008 18:58:11 -0700
Message-ID: <1208743090.165141@bubbleator.drizzle.com>

Jonathan Lewis wrote:
> ----- Original Message -----
> From: "Noons" <wizofoz2k_at_yahoo.com.au>
> Newsgroups: comp.databases.oracle.server
> Sent: Saturday, April 19, 2008 4:15 PM
> Subject: Re: Pros/cons of using as many table partitions as possible
>
>

>> Jonathan mentioned here a few years ago
>> about using thousands of partitions
>> in a table without any major problems.


> 

>     I'm not sure that I did - possibly around a couple of

>     thousand, like one partition per day for 7 years of

>     data, and then be careful about the number of  (local)

>     indexes.


I have one customer, a bank, partitioning every 15 minutes.
No issues related to the number of partitions have arisen.
-- 
Daniel A. Morgan

Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group
www.psoug.org Received on Sun Apr 20 2008 - 20:58:11 CDT