Re: CLUSTERS

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: 1998/06/17
Message-ID: <3587EC06.AB693285_at_access-laserpress.com>#1/1


If you use Oracle8 on Windows NT you get Partitioning for free :-)

MotoX wrote:
>
> Todd Bellaver wrote in message <6m51ff$ni5$1_at_news5.ispnews.com>...
> >Hello.
> >As you can imagine, these tables are highly fragmented and Oracle spends
> >days processing data (batch deletes for one week take 6+ hours alone!).
> >Because of the random and irratic storage of the data, week-to-week IO
> >balancing across disks become major maintanance jobs.
>
> Look at Oracle 8 and the *partitioning option* - NB. it is an additional
> *costed* option, you don't get it for free with Oracle 8.
>
> One of our clean-ups was also taking 6-7 *hours*. After partitioning, the
> clean-up is down to a few *seconds*. I also tend to use stored procedures
> which create the new partitions dynamically for each new months worth of
> data being added.
>
> MotoX.
  Received on Wed Jun 17 1998 - 00:00:00 CEST

Original text of this message