Re: URGENT : Oracle V7 with Parallel Query Option
From: <jl34778_at_corp02.d51.lilly.com>
Date: 15 Nov 94 18:22:55 EST
Message-ID: <1994Nov15.182255.1_at_corp02.d51.lilly.com>
>
> Yes, PQO does work, and it scales reliably according to the
> number of cpu's you can burn. No, not just any version; it has to
> be at least 7.1.3, the first production release of PQO. I designed
> an app that loaded monthly credit data for a major retailer; its
> largest table held close to 20 gigabytes. We found that with six
> cpu's, we could load about 1 Gb in 20 minutes, per table. We also
> found that full table rollups of about 7 to 9 million rows could be
> done in about 15 minutes. This is about 5 times faster than single
> threaded loading and querying. Better optimization of the disk array
> could yield a few percent better times.
> --
> Dave Mausner, Sr. Consultant, Braun Technology Group, Chicago.
Date: 15 Nov 94 18:22:55 EST
Message-ID: <1994Nov15.182255.1_at_corp02.d51.lilly.com>
In article <3a8vsb$6ep_at_News1.mcs.com>, dmausner_at_brauntech.com (Dave Mausner) writes:
> In article <3a8pgb$gpt_at_news.INbe.net>, Johan Hermans <jhermans_at_INnet.be> says:
>>Has somebody experience with [parallel query under osf/1]? >>Or with any Oracle V7 with the parallel query option ? >>Does it really work ? And with any version of Oracle on >>a Multi-processor ? Is it worthwile for *your* application >>(we're not calculting SPECints or playing Tetris here)
>
> Yes, PQO does work, and it scales reliably according to the
> number of cpu's you can burn. No, not just any version; it has to
> be at least 7.1.3, the first production release of PQO. I designed
> an app that loaded monthly credit data for a major retailer; its
> largest table held close to 20 gigabytes. We found that with six
> cpu's, we could load about 1 Gb in 20 minutes, per table. We also
> found that full table rollups of about 7 to 9 million rows could be
> done in about 15 minutes. This is about 5 times faster than single
> threaded loading and querying. Better optimization of the disk array
> could yield a few percent better times.
> --
> Dave Mausner, Sr. Consultant, Braun Technology Group, Chicago.
I have also been playing with it, and really like it. Remember, ORACLE only parallelizes queries if you are doing a full table scan. So, if you are doing primarily index scans, PQO won't do you any good for your queries. You can also use PQO for index builds and direct path loading. Both very nice.
-- Bob Swisshelm | swisshelm_at_Lilly.com | 317 276 5472 Eli Lilly and Company | Lilly Corporate Center | Indianapolis, IN 46285Received on Wed Nov 16 1994 - 00:22:55 CET