Re: Parallel Query

From: Fernando Pereira <morgan_at_cardume.com>
Date: Tue, 12 Sep 2000 18:18:43 -0400
Message-ID: <srtarhafct695@corp.supernews.com>

Are you using partitions with that table? And which Oracle version are you using?

And how about your hard drives? If you are going to do several parallel queries you would need several hard drives, not only CPUs. I don't imagine much difference with 2CPUs.

Fernando

"Dean" <d.j.l_at_btinternet.com> wrote in message news:8kibrr$ohd$1_at_neptunium.btinternet.com...
> Hi,
> Has anyone out there had any succes using Parallel Query?
> If so, can you give me a idea of the improvements seen, size of the tables
> (rows) and kit the RDBMS was running on.
>
> I'm struggling to get improvment on a 13Mill row table on a NT box with
> 2x800mghz processors.
> I'm going to try with a 4x200mghz NT and a 4 processor IBM UNIX box but
> would be grateful for any pointers first.
>
> Many thanks in advance
>
> Dean
>
>
>
Received on Tue Sep 12 2000 - 17:18:43 CDT