Troubleshooting
Problem
Oracle parallel query should not be enabled on a table or index in Content Engine environments. Oracle parallel query execution is useful generally in low-concurrency data warehousing environments. CE environments typically behave like Online Transaction Processing (OLTP) applications, where a smaller numbers of rows is returned using carefully chosen indexes rather than tablescans.
Symptom
Slow queries. Tablescans are present in query plans where indexes should have been used.
Async upgrade may also be slow, for example the following query will run slow with parallel query enabled on the docversion table as can be seen from P8 tracing as well:
SELECT object_id, mime_type FROM (SELECT object_id, mime_type FROM DocVersion WHERE ( object_id > ? ) ORDER BY object_id) WHERE ROWNUM <= 100
[{"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Content Engine","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"5.2.1;5.2.0;5.1.0;5.0;4.5.1;4.0.1","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSGLW6","label":"IBM Content Foundation"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Content Engine","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
28 April 2025
UID
swg21469922