Re: URGENT : Oracle V7 with Parallel Query Option

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.