Stability of the Parallel Query Option - PQO

From: Steve Orr <sorr_at_arzoo.com>
Date: Tue, 13 Mar 2001 16:25:43 -0800
Message-ID: <F001.002CB973.20010313145056@fatcity.com>

Has anyone experienced significant query failure after implementing PQO? In the past I've implemented PQO with good success by plugging it onto an extant working system without incident. But now I'm meeting quizzical resistance to its implementation. (Running Oracle 8.1.6.3.0 with 4 CPU's and 4GB of memory. The entire database is well striped on an EMC array.) In your opinion, how much testing should be done before implementing PQO on a production system? With CBO in a mixed OLTP/DSS environment, anyone care to enumerate the cost/benefits of PQO?

All opinions valued, whether humble or otherwise. :>)

TIA,
Steve Orr

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steve Orr
  INET: sorr_at_arzoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 13 2001 - 18:25:43 CST