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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
