Re: 90GB table on Windows 2000

Sorry, you lose.

There were no data problems (this wasn't a legacy system, or DW extract).

Mostly the problems were a combination
of timing and Oracle bugs. Viz: we had
to do things a certain way to avoid contention problems between loading and querying.

But the way we had to do things hit all
the worst places in the Oracle code for
the "I never thought anyone would do
that, and it was Friday afternoon so I
left early" bits of the partition code ;)

But I won't hold you to the GBP 100 -

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Paul Brewer wrote in message
<3dc05a22$1_3_at_mk-nntp-1.news.uk.worldonline.com>...


>>

>>

>I bet GBP 100 the problem wasn't load performance; it was dirty

data....


>It *always* is.

>

>Paul

>

>

>