Re: Parallel Query

Patrick Tan wrote:
>
> We recently installed 2nd CPU to HPUX 10.01 server. I configured Oracle
> 7.1.6 for Parallel Query. I tried configuring Parallel Query at instance
> level, table level and query level (using hint). It does not seem like
> it is working. I do not see any speed improvement on query that suppose
> to take advantage of parallel query. I can see ora_p000X processes
> running. I talk to Oracle Support and they said instance level and table
> level parallel query on 7.1.6 is not reliable and they also want me to
> install a patch to fix async I/O in HP. Please help.
>
> Patrick

Run an explain plan on the statement and add the "OTHER" column to the statement when getting the statement out of the plan table. This will tell you if Parallel Query was being used.

For an improvement in performance you need to a few other things into account. Like the number of data files for the tablespace, are they on separate disks, and how long did the query run before. Short running query usually do not see a performance gain because of the time to setup the parallel option.

Send an email if you need more info.

Greg Pucka
Management Consultant, TUSC
pucka_at_tusc.com Received on Fri Jan 31 1997 - 00:00:00 CST