Re: Use of parallel query

Potentially. Check your execution plans carefully and you I/O distribution. I recently set-up Oracle 8 on an NT server and found that (forced) parallel scans were slower, even though we had added more CPUs to the server. Problem was the extra horsepower just bottlenecked on I/O. After setting up the db across striped drives (3 of) the performance doubled. Nice.

It's the old "Tune. Check. Tune." loop. You can't do enough of it when you change configuration, IMHO.

Also, read the Oracle Manuals on Parallel Query, as not everything in Oracle is parallelised and not every application benefits from it. Tread carefully.

MotoX.

Olivier Bercovitz wrote in message <358EBE4A.C8249819_at_club-internet.fr>...
>Hi everybody,
>
>we plan to use parallel query option to select and update from a table
>with about 400K rows.
>is it a good idea ? do we have really improvement on execution time ?
>(we use O8 on solaris with 4 cpu)
>
>thanks in advance.
>
>regards. Olivier
>
Received on Wed Jun 24 1998 - 04:57:24 CDT