Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 90GB table on Windows 2000

Re: 90GB table on Windows 2000

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 30 Oct 2002 17:18:11 -0000
Message-ID: <app48s$mhr$1$8302bc10@news.demon.co.uk>

Correction - 32GB per week.

--
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





Jonathan Lewis wrote in message ...

>
>Sorry about leaving out the RELY all the way
>through - at least I remembered to include it
>at the end.
>
>The 'bug' is presumably related to the point that
>RELY exists to help the optimizer understand
>relationships between data - and therefore get
>the estimate somewhere in the right ballpark.
>
>Yes, I have done it, but the last time was on
>8.1.6, on a Sun, loading 32 GB of data per day,
>and we had far more serious problems than
>just working out how to deal with dropping and
>exchanging partitions - most (if not all) of which
>have been fixed in 8.1.7.4
>
>
>--
>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
>
>
>
Received on Wed Oct 30 2002 - 11:18:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US