Re: design question, use of partitioned tables?

Manuela Mueller <mueller_m_at_fiz-chemie.de> wrote in message news:<bgo51g$q4in4$1_at_uni-berlin.de>...

> OS: SuSe Enterprise Server SLES-8
> RDBMS: Oracle Standard Edition 9.2.0.3.0
> DB Size: 1 TB
> Tablespaces: Locally managed, uniform size 8 MB
> Datafiles: all 32 GB

I'm assuming a db_block_size of 8K based on above numbers?

> Currently I perform a load of 17 Mio records, which will take about 5
> days. This is far beyond my time frame.

That is FAR beyond anything I'd expect! WAY too slow. Something else is the matter and it's got nothing to do with partitioning, fragmentation, etc.

How is this data loaded? Third party program or some form of Oracle untility?
Do you drop all indexes on table before load?

Partitioning may help but without knowing a lot more about the specifics of your application it's difficult to suggest any given partitioning rule. Date is obvious, but things might not be that linear.

Anyways, you have some other problem now: there is NO WAY that loading 17 million rows can take 5 days unless there is something else very serious going on...

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Tue Aug 05 2003 - 19:46:01 CDT