Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!ihug.co.nz!logbridge.uoregon.edu!news-west.eli.net!not-for-mail
Message-ID: <3DD01814.E4D6FE65@exesolutions.com>
From: Daniel Morgan <dmorgan@exesolutions.com>
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle 8i Database with 18,000 Partitions
References: <7a7ecd29.0211110955.456e6112@posting.google.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 34
Date: Mon, 11 Nov 2002 20:50:28 GMT
NNTP-Posting-Host: 156.74.250.7
X-Complaints-To: yvonne.tracy@ci.seattle.wa.us
X-Trace: news-west.eli.net 1037047828 156.74.250.7 (Mon, 11 Nov 2002 13:50:28 MST)
NNTP-Posting-Date: Mon, 11 Nov 2002 13:50:28 MST
Organization: City of Seattle NewsReader Service
Xref: newsfeed1.easynews.com comp.databases.oracle.server:166578
X-Received-Date: Mon, 11 Nov 2002 13:50:19 MST (news.easynews.com)

Tom Glover wrote:

> First of all, I am not an Oracle DBA.  Secondly, this DB design is not
> my idea - so bashing the messager is not required (I'm just the poor
> sap that has to make the application around the database work!).
>
> I have a third party vendor who is pushing a customer database design
> that will contain over 15,000 partitions.  Basically, each customer
> will have a partition with approximately 30,000 - 50,000 records.  The
> partitions can be restored on a very regular basis (100 - 200
> customers per day possible). So, I have a few questions as to the
> feasibility of this design:
> 1.  What are the performance impacts of this many partitions? I have
> read numerous discussions about as many as 4,000 partitions and the
> general consensus was: you can do it, but you better be very,very good
> and careful.
> 2.  Is Oracle even designed to handle this volume of restores (100-200
> per day)? What are the pitfalls (maintainance???) to supporting this
> many restores.
> 3.  If the answers to the questions above lead to the point that this
> system can be made to work, what level of DBA do I need to 1)Create
> the database and stored procedures and 2) Maintain this monster of a
> system once it is turned over.
>
> Any help is greatly appreciated.

I'm with Jonathan on this one. Accident waiting to happen and maintenance
nightmare.

Either get another vendor. Very quickly! Or before this is implemented
revise your employement agreement to include hazard pay.

Daniel Morgan