Re: CLUSTERS

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 CDT