Parallel Query

From: Patrick Tan <ptan_at_mindspring.com>
Date: 1997/01/30
Message-ID: <32F1609B.4BC1@mindspring.com>#1/1

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 Received on Thu Jan 30 1997 - 00:00:00 CST