About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
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
More support for:
FileNet Content Manager
Software version:
5.2.1, 5.2.0, 5.1.0, 5.0, 4.5.1, 4.0.1
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
151727
Modified date:
28 April 2025
UID
swg21469922
Manage My Notification Subscriptions